Skip to content

Instantly share code, notes, and snippets.

@sdsykes
Created March 17, 2009 09:49
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 sdsykes/80431 to your computer and use it in GitHub Desktop.
Save sdsykes/80431 to your computer and use it in GitHub Desktop.
Country Load Scrooged (1.6ms) SELECT `countries`.id FROM `countries` WHERE (id IN
(10,33,48,70,81,82,90,124,136,146,147,170,175,176,186,181,54,80,94,185,194,27,45,63,131,40,7,
38,144,168,165,8,22,31,39,46,53,59,83,85,92,96,99,100,105,111,112,114,128,132,137,150,152,163,
164,171,172,177,190,196,198,199,207,62,180,25,126,9,339,342,47,89,208,6,119,43,293,24,345,115,
110,21,84,227,354,361,73,79,371,34,87,193,69,151,58,195,191,102,118,66,257,161,315,323,129,67,
17,28,159,68,134,366,65,265,18,229,61,77,64,331,184,255,359,349,356,50,149,299,365,357,41,358,
201,178,355,49,215,35,91,60,130,362,20,145,122,12,327,15,154,192,113,4,153,335,155,19,182,71,
169,95,52,74,200,108,138,101,107,123,187,368,13,2,72,16,11,360,135,55,376,188,156) AND continent='Asia')
SQL (1.2ms) SELECT `countries`.date,`countries`.country,`countries`.continent,`countries`.parent_country,
`countries`.official_name,`countries`.status,`countries`.highest_point,`countries`.height,
`countries`.population,`countries`.local_form,`countries`.capital_id,`countries`.gmt,
`countries`.dial_code,`countries`.comment,`countries`.good_for,`countries`.engine_index,
`countries`.affiliate,`countries`.featured_brochure,`countries`.short_name,
`countries`.text_indexed_at,`countries`.updated_at,`countries`.id FROM `countries` WHERE
`countries`.id IN ('8','11','13','21','31','39','41','66','80','83','84','85','89',
'92','94','95','99','100','102','112','113','118','123','128','135','137','138','145','149',
'163','169','171','177','178','181','187','192','196','199','299','345','354')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment