Skip to content

Instantly share code, notes, and snippets.

@kenton

kenton/gist:3933925

Created October 22, 2012 20:27
Show Gist options
  • Save kenton/3933925 to your computer and use it in GitHub Desktop.
Save kenton/3933925 to your computer and use it in GitHub Desktop.
Download ZIP
SQL queries
Raw
gistfile1.sql
ReservationPricing.with_promo_code
SELECT reservation_pricings.promo_code_id, reservation_pricings.reservation_request_id FROM `reservation_pricings` INNER JOIN reservation_requests ON reservation_requests.id = reservation_pricings.reservation_request_id WHERE (reservation_pricings.reservation_pricing_stage = 30 AND reservation_pricings.promo_code_id = 1 AND reservation_requests.parent_id IS NULL AND reservation_pricings.created_at >= '2012-10-19 20:47:57')
ReservationPricing.with_promo_code_and_user
SELECT reservation_pricings.promo_code_id, reservation_pricings.reservation_request_id, reservation_requests.user_id, reservation_requests.parent_id, users.id FROM `reservation_pricings` INNER JOIN reservation_requests ON reservation_requests.id = reservation_pricings.reservation_request_id INNER JOIN users ON reservation_requests.user_id = users.id WHERE (reservation_pricings.reservation_pricing_stage = 30 AND reservation_pricings.promo_code_id = 1 AND reservation_requests.parent_id IS NULL AND reservation_requests.user_id = 1125435 AND reservation_pricings.created_at >= '2012-10-19 20:47:57')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment