rest 5/5 - Quarry

This query is marked as a draft This query has been published by Trusttri.
SQL

select page_id, page_title, rev_id, rev_comment,rev_timestamp, rev_user, rev_user_text
from revision
join page on page_id=rev_page 
where page_id in (49912672, 2243425, 36264802, 364347, 6732644, 5692261, 2036881, 2530152, 12778345, 842215, 1148050, 45341550, 37588797, 359280, 4867765, 31602, 29070483, 53410189, 15612792, 14637945, 26946026, 28662655, 38254681, 3079042, 24095757, 39819, 2243468, 26057613, 31472526, 42158573, 408465, 3935941, 2979020, 1219477, 5716886, 506776, 3739460, 1997724, 4968696, 4176798, 7450437, 21920673, 32594852, 4194118, 875430, 23025, 28752808, 801706, 163655, 24779694, 5118896, 424884, 7715765, 37575607, 30694330, 1997755, 5389247, 20593600, 19192769, 6626242, 15299, 1719238, 43989959, 39259980, 24779723, 38394828, 19389390, 2423759, 30268368, 6006908, 507726, 5151225, 4725720, 26916004, 3873754, 2011190, 35617757, 30193716, 35494395, 4627428, 20782054, 12401639, 26041320, 4029417, 244714, 1237981, 14165834, 47692782, 506863, 2907120, 14433268, 18430966, 72698, 203771, 30809085, 5717760, 20790274, 1039364, 39941, 187399, 20651016, 12573705, 900106, 1265495, 1896623, 23218123, 2358293, 8010774, 53853207, 18949144, 16067270, 25066524, 10353695, 13417505, 15703074, 3595300, 964526, 1997866, 76295, 3835058, 47133513, 25984047, 7691312, 47898418, 6470706, 39566387, 6093878, 35867145, 37633080, 10277049, 27622458, 22318943, 2432061, 1260607, 21824814, 1547329, 20945992, 29952524, 9600074, 35953739, 6241356, 26631246, 2358352, 15227986, 10124372, 17882202, 5373019, 17089722, 4285655, 32613, 22453347, 6380645, 21486694, 1866855, 45298876, 3025673, 23662, 23460977, 890908, 867443, 26967156, 613493, 41319544, 27081849, 21249146, 6765691, 5061756, 588834, 1711230, 9978368, 41811074, 20975467, 1866885, 3775623, 38304905, 28200500, 608792, 35573266, 261267, 12936136, 343189, 1383574, 18816155, 23108765, 908446, 1352901, 429936, 21132160, 1440931, 7334, 146601, 33193130, 30811335, 1348881, 12197038, 22740143, 52231344, 2736526, 4850889, 42197375, 1899705, 40713403, 47545536, 31937, 310468, 433351, 6161612, 7552202, 8838347, 4037838, 16776399, 1948880, 11771090, 1965098, 4168916, 3095765, 25515687, 2997470, 305701, 10519831, 4283617, 26557667, 53361893, 40107238, 23608553, 2738004, 3382510, 9207024, 209763, 48373, 39795958, 1373434, 17325307, 52431402, 4136190, 269567, 31030530, 3489028, 27712773, 34340102, 6225163, 5144450, 3611919, 50715923, 50904340, 22461718, 284280, 44121371, 4437210, 36142367, 30363943, 6888738, 31722033, 42597673, 40746283, 2504392, 51582173, 37707056, 6397233, 10108215, 17079608, 1588539, 2071383, 1899842, 16621451, 13139268, 16047429, 2161990, 48151879, 2628937, 6348106, 27470391, 24296780, 2063693, 21560654, 20369293, 3063120, 163153, 49012050, 43056467, 449877, 150073, 30602084, 46747535, 351580, 638302, 20995423, 11238753, 4848994, 27048507, 449893, 2016386, 15585169, 4383320, 5351, 4078956, 26918802, 35741039, 39542130, 32118, 1236347, 8019326, 42253696, 1203587, 1891718, 39591306, 7060136, 3784076, 277058, 572814, 29695896, 33381779, 22545646, 9594286, 22266685, 1531289, 6970778, 6536604, 4082245, 9248160, 48561569, 2956706, 47938982, 15783, 15784, 26202012, 25271723, 18333102, 433583, 3055025, 40370, 6119856, 3177908, 499021, 2825655, 15048028, 39427513, 2186683, 739494, 11140544, 564673, 73154, 30047684, 28910838, 39329223, 11132360, 22904265, 25558475, 3194316, 37395919, 720336, 17949944, 1138131, 18438734, 3082195, 7640, 53345753, 12099034, 30433236, 1867229, 2833886, 2645473, 3366370, 17096166, 25728252, 35315181, 4916477, 6962674, 30924276, 3341815, 261624, 5765716, 2530810, 24878588, 3374590, 16764378, 32258, 2858500, 5347926, 1064454, 38493703, 1716140, 15882, 24678072, 41587970, 97806, 22535695, 34800023, 40492561, 4816404, 11181590, 23158295, 12107289, 39575066, 630011, 4513308, 49348127, 5210032, 20618787, 33594515, 1121830, 73255, 14297692, 25706027, 19381806, 3096111, 9876744, 3636789, 27344438, 12992055, 245684, 17547718, 51174972, 40205885, 2072126, 50093632, 2828896, 2186819, 3841604, 38714949, 6626886, 32180833, 2680619, 35978829, 18696772, 37789266, 8612451, 14175212, 2006617, 15851098, 11787869, 45653598, 269919, 21986912, 48988309, 10829755, 35806823, 179816, 106090, 17238631, 1891950, 44473968, 4046449, 11566706, 26768314, 21675639, 30572153, 28262010, 18715925, 204417, 37125763, 982277, 552099, 13560279, 7815, 6635144, 188042, 13180555, 36454030, 327311, 5512850, 21192341, 3464855, 220824, 5096089, 1253019, 41754271, 229024, 5471905, 2077979, 2170533, 8617640, 8339113, 12377770, 47210156, 5562029, 42352302, 41139887, 12631729, 12705458, 39001779, 4379934, 32349878, 5586615, 1597112, 354879, 34234042, 39927486, 2121407, 22912705, 1113794, 17156373, 46448325, 30334667, 28368588, 9870625, 155342, 17460475, 53714641, 9585955, 2610455, 499415, 9862872, 37281497, 65243, 24319269, 12132064, 48217827, 4161252, 2121445, 20913895, 26205928, 26033897, 4718314, 2977139, 81645, 188142, 19390191, 43605744, 10411761, 25190356, 1357651, 1711867, 53731068, 23420669, 53280510, 859903, 6799104, 37498043, 10821379, 34168581, 50028294, 12533511, 17403789, 48922377, 33890060, 21217038, 20946703, 14933777, 30318354, 25624339, 1182777, 990999, 43021615, 19390236, 41312030, 26353439, 39723401, 3204400, 13336358, 18793777, 16580392, 9958, 24367, 22019888, 32562, 23314227, 7544628, 53968862, 1171255, 47996728, 35389242, 1720287, 16189, 32235327, 2473792, 35282754, 3357323, 65348, 37306181, 21167942, 23617351, 23101259, 1245005, 614222, 36514445, 16210, 13732436, 44884979, 6422357, 1261398, 308537, 23510873, 26304347, 24756061, 286558, 11632480, 27241148, 25085075, 7610342, 14983015, 163691, 760948, 43401070, 972093, 36298608, 42426226, 32857971, 30220153, 11845498, 1187707, 6397820, 34086781, 27658901, 35151746, 3010539, 54706053, 4584106, 2785161, 3817355, 43966351, 12382986, 4800401, 10051474, 25132947, 65428, 8454038, 22978455, 7593880, 3573060, 1769455, 3776412, 20414365, 9786615, 4579233, 45694883, 2334628, 2588657, 4715847, 237484, 29884335, 1408944, 1697096, 38322098, 647091, 42246068, 35779913, 32010228, 24928187, 7905212, 5332929, 38232002, 53436357, 1810375, 6119470, 5840841, 2768842, 25477067, 26124236, 3736909, 810962, 5890464, 22454228, 3276758, 52600792, 39550938, 296271, 16965597, 30228446, 4070053, 18415584, 2850785, 237538, 12128251, 24428516, 5264156, 44343272, 26386428, 30564330, 27828203, 5783532, 507886, 26820591, 40624112, 14184, 1056755, 31029929, 9691128, 188411, 39714812, 17950037) and (rev_comment like '%Adding RFC ID%' or rev_comment like '%Removing expired RFC template%');
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
