Skip to content

Instantly share code, notes, and snippets.

@JonCrawford
Created October 30, 2014 00:13
Show Gist options
  • Save JonCrawford/e91224f2c85ae239061a to your computer and use it in GitHub Desktop.
Save JonCrawford/e91224f2c85ae239061a to your computer and use it in GitHub Desktop.
Vanity ID SNAFU Recovery
SELECT orders.id, orders.vanity_id, orders.payment_state, orders.confirmed_at, orders.store_id, store_subdomain from orders WHERE orders.vanity_id < 100000 and orders.confirmed_at > DATE_SUB(NOW(), INTERVAL 5 DAY) AND orders.store_id IN (528222, 18784) order by vanity_id, store_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment