Skip to content

Instantly share code, notes, and snippets.

@eranroz
Created April 2, 2016 14:54
Show Gist options
  • Save eranroz/88f7dd4c568a764fb8150375942b2223 to your computer and use it in GitHub Desktop.
Save eranroz/88f7dd4c568a764fb8150375942b2223 to your computer and use it in GitHub Desktop.
select rev_id from revision where
(rev_timestamp>20150228210000 and rev_timestamp<20150301000000) OR
(rev_timestamp>20150301060000 and rev_timestamp<20150301070000) OR
(rev_timestamp>20150404090000 and rev_timestamp<20150404100000) OR
(rev_timestamp>20150404130000 and rev_timestamp<20150404140000) OR
(rev_timestamp>20150404170000 and rev_timestamp<20150407200000) OR
(rev_timestamp>20150408000000 and rev_timestamp<20150408010000) OR
(rev_timestamp>20150408130000 and rev_timestamp<20150408140000) OR
(rev_timestamp>20150408170000 and rev_timestamp<20150410200000) OR
(rev_timestamp>20150410230000 and rev_timestamp<20150411000000) OR
(rev_timestamp>20150411010000 and rev_timestamp<20150411030000) OR
(rev_timestamp>20150416190000 and rev_timestamp<20150416200000) OR
(rev_timestamp>20150417040000 and rev_timestamp<20150417050000) OR
(rev_timestamp>20150417070000 and rev_timestamp<20150417080000) OR
(rev_timestamp>20150505000000 and rev_timestamp<20150505010000) OR
(rev_timestamp>20150509160000 and rev_timestamp<20150509210000) OR
(rev_timestamp>20150608190000 and rev_timestamp<20150608220000) OR
(rev_timestamp>20150614080000 and rev_timestamp<20150614090000) OR
(rev_timestamp>20150615180000 and rev_timestamp<20150616010000) OR
(rev_timestamp>20150616020000 and rev_timestamp<20150616060000) OR
(rev_timestamp>20150616070000 and rev_timestamp<20150617120000) OR
(rev_timestamp>20150624220000 and rev_timestamp<20150624230000) OR
(rev_timestamp>20150625110000 and rev_timestamp<20150625130000) OR
(rev_timestamp>20150625140000 and rev_timestamp<20150625160000) OR
(rev_timestamp>20150701050000 and rev_timestamp<20150701070000) OR
(rev_timestamp>20150701120000 and rev_timestamp<20150701130000) OR
(rev_timestamp>20150701140000 and rev_timestamp<20150701150000) OR
(rev_timestamp>20150702020000 and rev_timestamp<20150702030000) OR
(rev_timestamp>20150702040000 and rev_timestamp<20150702050000) OR
(rev_timestamp>20150702140000 and rev_timestamp<20150702160000) OR
(rev_timestamp>20150702190000 and rev_timestamp<20150702230000) OR
(rev_timestamp>20150703000000 and rev_timestamp<20150703220000) OR
(rev_timestamp>20150710050000 and rev_timestamp<20150710090000) OR
(rev_timestamp>20150714070000 and rev_timestamp<20150724230000) OR
(rev_timestamp>20150725160000 and rev_timestamp<20150725170000) OR
(rev_timestamp>20150725220000 and rev_timestamp<20150725230000) OR
(rev_timestamp>20150726000000 and rev_timestamp<20150726010000) OR
(rev_timestamp>20150726020000 and rev_timestamp<20150726030000) OR
(rev_timestamp>20150726130000 and rev_timestamp<20150726140000) OR
(rev_timestamp>20150726150000 and rev_timestamp<20150726160000) OR
(rev_timestamp>20150726190000 and rev_timestamp<20150726220000) OR
(rev_timestamp>20150726230000 and rev_timestamp<20150727010000) OR
(rev_timestamp>20150727030000 and rev_timestamp<20150727070000) OR
(rev_timestamp>20150727180000 and rev_timestamp<20150727220000) OR
(rev_timestamp>20150728200000 and rev_timestamp<20150729040000) OR
(rev_timestamp>20150729210000 and rev_timestamp<20150730070000) OR
(rev_timestamp>20150730200000 and rev_timestamp<20150731010000) OR
(rev_timestamp>20150731030000 and rev_timestamp<20150731040000) OR
(rev_timestamp>20150731080000 and rev_timestamp<20150731090000) OR
(rev_timestamp>20150731100000 and rev_timestamp<20150731150000) OR
(rev_timestamp>20150731170000 and rev_timestamp<20150731180000) OR
(rev_timestamp>20150731190000 and rev_timestamp<20150801000000) OR
(rev_timestamp>20150801150000 and rev_timestamp<20150801160000) OR
(rev_timestamp>20150801190000 and rev_timestamp<20150801200000) OR
(rev_timestamp>20150801230000 and rev_timestamp<20150802000000) OR
(rev_timestamp>20150803040000 and rev_timestamp<20150803050000) OR
(rev_timestamp>20150803060000 and rev_timestamp<20150803080000) OR
(rev_timestamp>20150803170000 and rev_timestamp<20150803180000) OR
(rev_timestamp>20150803190000 and rev_timestamp<20150804210000) OR
(rev_timestamp>20150805050000 and rev_timestamp<20150805080000) OR
(rev_timestamp>20150805090000 and rev_timestamp<20150805100000) OR
(rev_timestamp>20150805120000 and rev_timestamp<20150805160000) OR
(rev_timestamp>20150806200000 and rev_timestamp<20150807020000) OR
(rev_timestamp>20150815080000 and rev_timestamp<20150815090000) OR
(rev_timestamp>20150816210000 and rev_timestamp<20150817020000) OR
(rev_timestamp>20150817080000 and rev_timestamp<20150817110000) OR
(rev_timestamp>20150817170000 and rev_timestamp<20150818010000) OR
(rev_timestamp>20150831040000 and rev_timestamp<20150831050000) OR
(rev_timestamp>20150831060000 and rev_timestamp<20150831170000) OR
(rev_timestamp>20150909180000 and rev_timestamp<20150910060000) OR
(rev_timestamp>20150914200000 and rev_timestamp<20150915000000) OR
(rev_timestamp>20150921220000 and rev_timestamp<20150922000000) OR
(rev_timestamp>20150923200000 and rev_timestamp<20150923210000) OR
(rev_timestamp>20150923230000 and rev_timestamp<20150924000000) OR
(rev_timestamp>20150924070000 and rev_timestamp<20150924080000) OR
(rev_timestamp>20150924090000 and rev_timestamp<20150924120000) OR
(rev_timestamp>20150925190000 and rev_timestamp<20150925210000) OR
(rev_timestamp>20150925220000 and rev_timestamp<20150926000000) OR
(rev_timestamp>20150926050000 and rev_timestamp<20150926090000) OR
(rev_timestamp>20150926100000 and rev_timestamp<20150926150000) OR
(rev_timestamp>20151006020000 and rev_timestamp<20151024100000) OR
(rev_timestamp>20151030210000 and rev_timestamp<20151030220000) OR
(rev_timestamp>20151030230000 and rev_timestamp<20151031050000) OR
(rev_timestamp>20151031060000 and rev_timestamp<20151031170000) OR
(rev_timestamp>20151031190000 and rev_timestamp<20151031220000) OR
(rev_timestamp>20151031230000 and rev_timestamp<20151101000000) OR
(rev_timestamp>20151101010000 and rev_timestamp<20151101060000) OR
(rev_timestamp>20151109170000 and rev_timestamp<20151109180000) OR
(rev_timestamp>20151110040000 and rev_timestamp<20151110080000) OR
(rev_timestamp>20151110090000 and rev_timestamp<20151110130000) OR
(rev_timestamp>20151113000000 and rev_timestamp<20151113080000) OR
(rev_timestamp>20151116230000 and rev_timestamp<20151117060000) OR
(rev_timestamp>20151124020000 and rev_timestamp<20151124130000) OR
(rev_timestamp>20151124180000 and rev_timestamp<20151126140000) OR
(rev_timestamp>20151201170000 and rev_timestamp<20151201180000) OR
(rev_timestamp>20151201190000 and rev_timestamp<20151202000000) OR
(rev_timestamp>20151202010000 and rev_timestamp<20151202050000) OR
(rev_timestamp>20151202060000 and rev_timestamp<20151202130000) OR
(rev_timestamp>20151202140000 and rev_timestamp<20151203100000) OR
(rev_timestamp>20151205170000 and rev_timestamp<20151205230000) OR
(rev_timestamp>20151210010000 and rev_timestamp<20151210020000) OR
(rev_timestamp>20151210230000 and rev_timestamp<20151211010000) OR
(rev_timestamp>20151211020000 and rev_timestamp<20151211050000) OR
(rev_timestamp>20151211060000 and rev_timestamp<20151211120000) OR
(rev_timestamp>20151214230000 and rev_timestamp<20151215230000) OR
(rev_timestamp>20151216000000 and rev_timestamp<20151216050000) OR
(rev_timestamp>20151218080000 and rev_timestamp<20151218120000) OR
(rev_timestamp>20151218160000 and rev_timestamp<20151218190000) OR
(rev_timestamp>20151220200000 and rev_timestamp<20151220220000) OR
(rev_timestamp>20151221000000 and rev_timestamp<20151221040000) OR
(rev_timestamp>20151221080000 and rev_timestamp<20151221120000) OR
(rev_timestamp>20151221160000 and rev_timestamp<20151222030000) OR
(rev_timestamp>20151222080000 and rev_timestamp<20151222090000) OR
(rev_timestamp>20151222100000 and rev_timestamp<20151222120000) OR
(rev_timestamp>20151222200000 and rev_timestamp<20151223050000) OR
(rev_timestamp>20151223120000 and rev_timestamp<20151223130000) OR
(rev_timestamp>20151223160000 and rev_timestamp<20151223230000) OR
(rev_timestamp>20151224000000 and rev_timestamp<20151224070000) OR
(rev_timestamp>20151224080000 and rev_timestamp<20151224090000) OR
(rev_timestamp>20151226120000 and rev_timestamp<20151227010000) OR
(rev_timestamp>20151227020000 and rev_timestamp<20151227030000) OR
(rev_timestamp>20151227040000 and rev_timestamp<20151227090000) OR
(rev_timestamp>20151227100000 and rev_timestamp<20151227160000) OR
(rev_timestamp>20151229200000 and rev_timestamp<20151229220000) OR
(rev_timestamp>20151230040000 and rev_timestamp<20151230050000) OR
(rev_timestamp>20151230060000 and rev_timestamp<20151230070000) OR
(rev_timestamp>20151230090000 and rev_timestamp<20151230100000) OR
(rev_timestamp>20151230110000 and rev_timestamp<20151230180000) OR
(rev_timestamp>20151230200000 and rev_timestamp<20151230220000) OR
(rev_timestamp>20151231000000 and rev_timestamp<20151231010000) OR
(rev_timestamp>20151231040000 and rev_timestamp<20151231050000) OR
(rev_timestamp>20160104000000 and rev_timestamp<20160104160000) OR
(rev_timestamp>20160104200000 and rev_timestamp<20160104230000) OR
(rev_timestamp>20160105000000 and rev_timestamp<20160105110000) OR
(rev_timestamp>20160105120000 and rev_timestamp<20160105140000) OR
(rev_timestamp>20160105160000 and rev_timestamp<20160105170000) OR
(rev_timestamp>20160105180000 and rev_timestamp<20160106000000) OR
(rev_timestamp>20160106010000 and rev_timestamp<20160106020000) OR
(rev_timestamp>20160106030000 and rev_timestamp<20160106040000) OR
(rev_timestamp>20160109120000 and rev_timestamp<20160109140000) OR
(rev_timestamp>20160110060000 and rev_timestamp<20160110070000) OR
(rev_timestamp>20160116160000 and rev_timestamp<20160116190000) OR
(rev_timestamp>20160116210000 and rev_timestamp<20160117000000) OR
(rev_timestamp>20160117050000 and rev_timestamp<20160117080000) OR
(rev_timestamp>20160122000000 and rev_timestamp<20160122070000) OR
(rev_timestamp>20160122080000 and rev_timestamp<20160122140000) OR
(rev_timestamp>20160122200000 and rev_timestamp<20160123000000) OR
(rev_timestamp>20160123040000 and rev_timestamp<20160123110000) OR
(rev_timestamp>20160123120000 and rev_timestamp<20160124040000) OR
(rev_timestamp>20160128000000 and rev_timestamp<20160128090000) OR
(rev_timestamp>20160128120000 and rev_timestamp<20160128210000) OR
(rev_timestamp>20160212070000 and rev_timestamp<20160212110000) OR
(rev_timestamp>20160212120000 and rev_timestamp<20160212210000) OR
(rev_timestamp>20160213160000 and rev_timestamp<20160213190000) OR
(rev_timestamp>20160213200000 and rev_timestamp<20160213230000) OR
(rev_timestamp>20160214000000 and rev_timestamp<20160214020000) OR
(rev_timestamp>20160214030000 and rev_timestamp<20160214120000) OR
(rev_timestamp>20160214160000 and rev_timestamp<20160215140000) OR
(rev_timestamp>20160216000000 and rev_timestamp<20160216110000) OR
(rev_timestamp>20160219000000 and rev_timestamp<20160220140000) OR
(rev_timestamp>20160220160000 and rev_timestamp<20160220200000) OR
(rev_timestamp>20160221000000 and rev_timestamp<20160221010000) OR
(rev_timestamp>20160229160000 and rev_timestamp<20160301010000) OR
(rev_timestamp>20160301040000 and rev_timestamp<20160302110000) OR
(rev_timestamp>20160302120000 and rev_timestamp<20160302210000) OR
(rev_timestamp>20160308160000 and rev_timestamp<20160308170000) OR
(rev_timestamp>20160308200000 and rev_timestamp<20160308210000) OR
(rev_timestamp>20160314000000 and rev_timestamp<20160314060000) OR
(rev_timestamp>20160314070000 and rev_timestamp<20160314090000) OR
(rev_timestamp>20160314100000 and rev_timestamp<20160315010000) OR
(rev_timestamp>20160315040000 and rev_timestamp<20160315090000) OR
(rev_timestamp>20160321000000 and rev_timestamp<20160321170000) OR
(rev_timestamp>20160321200000 and rev_timestamp<20160323000000) OR
(rev_timestamp>20160324040000 and rev_timestamp<20160324110000) OR
(rev_timestamp>20160324120000 and rev_timestamp<20160324230000) OR
(rev_timestamp>20160325000000 and rev_timestamp<20160325030000) OR
(rev_timestamp>20160325070000 and rev_timestamp<20160325080000) OR
(rev_timestamp>20160325190000 and rev_timestamp<20160325200000) OR
(rev_timestamp>20160325210000 and rev_timestamp<20160325230000)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment