Skip to content

Instantly share code, notes, and snippets.

View snoble's full-sized avatar

Steven Klaiber-Noble snoble

View GitHub Profile
echo -e "\nbody {background-image: url('https://dl.dropbox.com/s/515ruct9cor67gj/sb.jpg') "'!'"important;}\n" >> ~/Library/Application\ Support/Google/Chrome/Default/User\ StyleSheets/Custom.css
@snoble
snoble / gist:1848714
Created February 16, 2012 23:24
one more idea
create table internal.fedex_bad1 AS
select o1.order_id, o1.shipping_address_id, o1.created_at, o1.email
from orders o1
JOIN addresses a ON (o1.shipping_address_id = a.address_id)
JOIN internal.address_hashes ah ON (ah.address_id = a.address_id)
where
o1.financial_status = 'paid'
AND o1.created_at >= '2010-07-01'
AND o1.created_at <= '2011-07-01'
AND NOT EXISTS (