Skip to content

Instantly share code, notes, and snippets.

@teamon
Created January 15, 2009 20:11
Show Gist options
  • Save teamon/47594 to your computer and use it in GitHub Desktop.
Save teamon/47594 to your computer and use it in GitHub Desktop.
~ SELECT "id", "permalink", "title", "template", "site_id" FROM "pages" WHERE ("site_id" IN (4, 10, 1, 7, 6, 3, 9, 2, 8, 5)) ORDER BY "id"
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 1)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 2)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 3)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 4)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 5)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 6)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 7)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 8)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 9)
~ SELECT COUNT(*) FROM "pages" WHERE ("site_id" = 10)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment