Skip to content

Instantly share code, notes, and snippets.

@tom-lord

tom-lord/lease_deals_error_2.sql

Created October 12, 2018 12:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tom-lord/135cbbff84ab20e6cf5f9f47dd684b7a to your computer and use it in GitHub Desktop.
Save tom-lord/135cbbff84ab20e6cf5f9f47dd684b7a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
lease_deals_error_2.sql
SELECT "lease_deals"."id"
FROM "lease_deals"
WHERE "lease_deals"."expired_at" IS NULL
AND "lease_deals"."dealership_id" = 1234
AND ( updated_at < '2018-10-09 09:34:11.818701' )
ORDER BY "lease_deals"."id" ASC
LIMIT 1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment