Skip to content

Instantly share code, notes, and snippets.

View sabarasaba's full-sized avatar

Ignacio Rivas sabarasaba

View GitHub Profile
@sabarasaba
sabarasaba / gist:1361520
Created November 13, 2011 03:00
Delete duplicates from a mysql table.
DELETE FROM someTable
USING someTable, someTable as virtualTable
WHERE (NOT someTable.id = virtualTable.id)
AND (someTable.name = virtualTable.name)
{
"status": "ok",
"status_message": "Query was successful",
"data": {
"movie_count": 3749,
"limit": 20,
"page_number": 1,
"movies": [
{
"id": 3753,
{
"request" : {
"country" : "uk",
"language" : "en",
"listing_type" : "buy",
"location" : "soho",
"num_res" : "20",
"offset" : 0,
"output" : "json_xs",
"page" : 1,
<link rel="import" href="../paper-tabs/paper-tabs.html">
<link rel="import" href="../paper-tabs/paper-tab.html">
<link rel="import" href="../core-animated-pages/core-animated-pages.html">
<link rel="import" href="../core-animated-pages/transitions/hero-transition.html">
<link rel="import" href="../core-animated-pages/transitions/cross-fade.html">
<link rel="import" href="../core-animated-pages/transitions/slide-down.html">
<link rel="import" href="../core-animated-pages/transitions/slide-up.html">
<link rel="import" href="../core-animated-pages/transitions/tile-cascade.html">
<link rel="import" href="../paper-input/paper-input.html">
<link rel="import" href="../core-icons/core-icons.html">
@sabarasaba
sabarasaba / index.html
Created June 6, 2014 16:48
A Pen by Ignacio Rivas.
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<!-- NAVBAR
================================================== -->
<body>
@sabarasaba
sabarasaba / gist:9b91ef2a843974288734
Created May 30, 2014 16:10
Sublime productivity
Select quotes, brackets ->
ctrl + shfit + space
Switch between tabs ->
ctrl + <1..2..3..?>
Move current tab to panel:
ctrl + shift + <1..2..3..?>
" Use Vim settings, rather then Vi settings (much better!).
" This must be first, because it changes other options as a side effect.
set nocompatible
" TODO: this may not be in the correct place. It is intended to allow overriding <Leader>.
" source ~/.vimrc.before if it exists.
if filereadable(expand("~/.vimrc.before"))
source ~/.vimrc.before
endif