Skip to content

Instantly share code, notes, and snippets.

@valguss

valguss/sql_commands.sql

Last active August 29, 2015 14:07
Show Gist options
  • Save valguss/bd51ef4d0cf828e10bbd to your computer and use it in GitHub Desktop.
Save valguss/bd51ef4d0cf828e10bbd to your computer and use it in GitHub Desktop.
Download ZIP
Useful SQL Commands
Raw
sql_commands.sql
#get coupons from skycart
select * from coupons c WHERE c.coupon_type = 'G' AND c.coupon_id NOT IN (SELECT coupon_id FROM coupon_redeem_track)
#SELECT * from customers c, coupon_gv_customer cgc WHERE c.customers_id = cgc.customer_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment