Skip to content

Instantly share code, notes, and snippets.

@jaredlewis

jaredlewis/gist:5620619

Created May 21, 2013 15:18
Show Gist options
  • Save jaredlewis/5620619 to your computer and use it in GitHub Desktop.
Save jaredlewis/5620619 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT
story.id
FROM stories_story AS story
JOIN stories_storyprovider AS storyprovider
ON story.id = storyprovider.story_id
JOIN sources_provider AS provider
ON storyprovider.provider_id = provider.id
WHERE (provider.uuid IN ('ca940d2324cc4d5886f7feb7717e3a49','1030c332bbb949528765360f029e4d02','5897643055f9490bb6f0141a9a81a710','953bd4d9973b40a8b10c69605fdb74ac','aa1d51cb09e444309a3b68222b1a1c08','f511a1abad5d4aeca81da152098645ca','e233709c3d83461b85f8cf7fc0d7ec90','930c8e2efdae4491ac1afedbbdccbfd5','e993414531044801bb0fe5f2cd5e7f5e','c8339c8ec5c04a25a36b129a5e0b3439','0c0e0d2f935c463a8131b78c327ca7fa','8e924759c7f34d82b86533418dedb84a','fb3f76510c7f4a1a83dc6377e4cb2b42','70d8039a46414d5f8c62fe25fc989a06','a43722a132c14b919b9595f0d4570acc','a8c831514b4d401b9e3ee55d862c611d','0bd975a50bd546cb8c261404ed24d1c2','c08a5ecf91b64e16a56dfb111632511a','eac9e90c0f9e48b794750287253b49c7','9d3bd390e6a847dfba9a29f0acec45fb','fec806b058a44a77944e0071eb333087','dce357ef4a2a4f319e6e5fcbaa18b8c1','bb5adab48f70467d9d45fe028dd5297b','cf372d72a8f844658d62a04a19585c95','583c3a901e154dc49799b1473179450c','92a5715cb821449e9bac5e372bb32e34','c05db4d2eba64b79b4d12518479ca01d','1b03685748d54bbfb7a1185259901d0f'))
GROUP BY story.id
ORDER BY update_time DESC
LIMIT 25
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment