rest1/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 (845511, 3170307, 18112517, 41631754, 49381387, 5152780, 1949710, 12075023, 106514, 7127061, 43437616, 999448, 15737103, 6590110, 10001071, 18636805, 1466401, 19442523, 32170021, 180262, 11958961, 5513256, 12009515, 1015853, 3538990, 13006173, 30556211, 1679415, 6495499, 43458617, 40064351, 3661884, 7413770, 29016126, 34209855, 2374301, 14598155, 4710468, 46825541, 1269833, 15409228, 41656398, 13096, 82000, 26837006, 6070359, 17760344, 23265369, 19554395, 1966176, 29106273, 21037154, 5073595, 8274025, 26124396, 450669, 6652015, 715785, 15253621, 23634038, 1704056, 35647508, 32186490, 174783, 14151961, 11543914, 12522859, 639109, 2162822, 2722497, 1138825, 82060, 46399629, 13598862, 40650093, 14491792, 6152338, 28207081, 23863445, 25435338, 30752921, 29721297, 52256923, 3283761, 27673968, 1642141, 2244773, 19685542, 573608, 9732266, 3227821, 46997678, 952715, 30046920, 20390066, 1065140, 65717, 2506939, 1163455, 31170753, 15278274, 10955, 98502, 11665607, 11075784, 32969, 36643018, 10302839, 27459788, 13987874, 164046, 703181, 1261776, 39551185, 21291219, 24010966, 34455771, 1655006, 32805, 1383833, 8417, 35987685, 1933490, 48324842, 10436845, 3244270, 17178863, 450800, 4907048, 49394, 42615027, 999668, 4060542, 39026935, 41958100, 106747, 2031869, 6422782, 2883839, 3358978, 1261827, 37755748, 2812630, 31990022, 5539201, 21586184, 1855532, 65802, 8438027, 20921595, 1278223, 6594832, 1755910, 27449841, 24852, 2064661, 9470231, 3440922, 16695580, 43655455, 4234958, 52449083, 1040674, 41686406, 1145221, 6177064, 38437162, 37798189, 23675182, 23732530, 4170038, 3233161, 22937913, 48619836, 2383584, 31301950, 9691457, 11084098, 10019140, 2679109, 14311751, 32784712, 20357449, 11911211, 11043148, 1884494, 14714284, 26878008, 180563, 40010069, 44302678, 34398551, 19595608, 10232154, 402831, 29491548, 393565, 770398, 8948453, 20848992, 6488417, 606562, 21406051, 19276132, 584422, 4150398, 7594350, 30239930, 2769265, 23855474, 47440243, 16843126, 32475881, 5005688, 4792698, 20603259, 3867005, 11329919, 3916160, 34898305, 54624712, 6819905, 2359688, 3785097, 11043210, 38936971, 25797005, 28615054, 3219855, 18637200, 6652305, 450963, 38176977, 467351, 4799215, 197022, 3383712, 2022128, 8069540, 39928230, 24101289, 950698, 31236523, 475564, 213421, 11108782, 9085360, 7905713, 42885556, 13148598, 18813001, 51151288, 24740281, 475578, 20805023, 2619241, 44024254, 25698751, 16900544, 8728237, 5464514, 5472708, 418246, 42385275, 48939464, 475594, 41252097, 9634, 47374798, 35586513, 25045, 3129815, 1847026, 12779994, 934363, 6455774, 17829, 1573344, 33153104, 32328443, 33989092, 45605351, 2728424, 6374398, 5849580, 47669741, 26984942, 3809777, 10363378, 19472402, 27836916, 36234264, 4547063, 27206137, 38339068, 1712637, 69717, 37187912, 15184183, 46304971, 41583107, 9069060, 4489733, 12730889, 5464588, 352781, 24789990, 131600, 4817425, 47047186, 401939, 47740, 30859797, 852504, 14688794, 71087, 47440413, 38126110, 18717445, 49697, 43088646, 3023401, 30433836, 5104174, 11436591, 2597424, 2818609, 31957554, 30810677, 903945, 606776, 2187833, 1663546, 25149, 49977868, 16923403, 10207841, 18752070, 1532487, 1860171, 37921358, 21578321, 1008591, 20394347, 23902990, 26174039, 66136, 5399129, 2351706, 35045981, 666189, 4704973, 1021371, 29114980, 10489958, 18842214, 15221353, 28838861, 4142223, 12911213, 24415299, 2140545, 26378865, 1032818, 11993715, 1000052, 23078560, 172137, 1950328, 7570042, 17466046, 23134846, 44171904, 47579777, 2474628, 172677, 41738889, 8724152, 1286796, 42345103, 39117456, 4045592, 8060073, 5030553, 33120924, 2530074, 38589893, 877218, 4406043, 1999524, 9879, 126048, 456312, 22332077, 14607022, 148143, 11847112, 52396723, 12108468, 2202398, 1352375, 47825594, 238270, 205503, 40609965, 12534466, 47751875, 28196982, 28061097, 770759, 4850378, 44516044, 9756792, 38255317, 10047968, 38585048, 9962202, 3285723, 53969628, 1860318, 30991071, 19268320, 3366857, 508491, 36881123, 1229540, 82661, 4611413, 38397393, 3941097, 23647698, 2272040, 51675890, 31458771, 475892, 48308982, 246523, 23849770, 271102, 3777280, 7561986, 526690, 44741, 1298561, 6152969, 30932745, 6669070, 3619629, 5601615, 312083, 8946456, 754457, 2101270, 30860059, 2590170, 20783872, 39682181, 37165872, 13812515, 7979813, 6718247, 42828587, 39617325, 11772718, 5767985, 48562994, 36365108, 53306165, 34112310, 623415, 8561464, 37597369, 1844027, 5342013, 484163, 18973508, 36807493, 8094849, 38691659, 9864013, 1245325, 911940, 8612664, 27239251, 48292696, 9049, 25435, 418652, 9372509, 38019934, 4200061, 41984865, 623458, 10724195, 35398500, 38397454, 28823048, 28246889, 6211047, 2278253, 885614, 336751, 41461123, 46679528, 156530, 3031187, 1196917, 35955576, 32067732, 140154, 1009130, 5063550, 7963519, 27033050, 19907457, 33754957, 21857159, 27967173, 19555209, 44295050, 18973579, 37258125, 28110498, 31023247, 51028885, 18449302, 2736281, 31946, 3851163, 18973596, 44258176, 9577382, 2360231, 27157416, 148395, 8004525, 2663342, 12665775, 13591472, 12600241, 746418, 25125811, 443319, 1270713, 4411551, 32072636, 38308682, 35693502, 5120959, 4531136, 828353, 14754754, 1747740, 951236, 31940137, 45011105, 32187336, 34833353, 6808522, 4309964, 25404365, 36971471, 47176405, 66516, 6538197, 1213398, 2073559, 4367320, 11084761, 5399514, 295899, 33620957, 2089950, 7488480, 11117538, 43312100, 3850406, 36766694, 27124711, 6292456, 6202350, 42583023, 852976, 17393, 66547, 1377270, 40584183, 10822648, 205817, 12809628, 45401086, 1024, 3003904, 4968619, 6018162, 50182, 3785735, 1063886, 38749194, 66571, 21767180, 574478, 36201487, 541713, 31482898, 181267, 28517396, 35988502, 26045273, 7947288, 19367428, 39424175, 5710876, 10434688, 8569887, 18793504, 27821089, 42470235, 35677220, 14651569, 10576936, 320554, 1205767, 5358636, 6504626, 590896, 140337, 377906, 295987, 173108, 3703862, 7514103, 631865, 7005242, 6456379, 3228735, 48317504, 38611856, 1235741, 19784776, 46870347, 52520011, 6939724, 50258, 91220, 960986, 49157716, 3748025, 140377, 3384410, 2659855, 9487452, 22234206, 33530975, 35374177, 35762363, 14823, 1555716, 10871911, 1369192, 12098787, 22176878, 1426543, 18541416, 615540, 74870, 50615893, 4252797, 49103999, 22889601, 20956290, 19186820, 38339719, 19375243, 574607, 29817623, 37930130, 2573459, 14301208, 54371479, 16688282, 304283, 42853535, 33023136, 28707696, 30860450, 49108507, 2794660, 36424561, 5334184, 13313193, 34388304, 14402733, 622792, 37536946, 30392564, 33129653, 66742, 286921, 25785, 46638266, 28604015, 43934908, 2327741, 10757219, 12584132, 27485381, 58566, 6284487, 44442825, 34691703, 40019148, 25470157, 8753359, 9684093, 50390, 49300695, 27436580, 32605402, 11886799, 17949916, 2082013, 1082595, 3851495, 17949934, 5842159, 319699, 722925, 9274613, 42353910, 17655, 3196152, 7808250, 39142954, 38798590, 52749570, 4593195, 394501, 39421190, 48866568, 9815305, 11805962, 19596555, 9069836, 17268244, 3679503, 19125371, 1352980, 384121, 11871512, 6137113, 24069402, 25885, 52200736, 5555760, 24495394, 35677475, 24544549, 52757798, 3396729, 13355911, 1811000, 31319341, 1918254, 5244208, 14609288, 353587, 499934, 1623350, 255287, 24923508, 337215, 197953, 12117314, 2008387, 443716, 7570757, 58696, 49890637, 11732302, 88973, 29877584, 75092, 27704206, 1492310, 4220247, 25970008, 14656858, 6481247, 3401056, 43920, 12952931, 2598244, 39765349, 9403281, 16663913, 18752874, 419179, 34227564, 30860653, 23872879, 4670832, 38372723, 36671837, 189815, 40879480, 10265979, 37823870, 2033024, 5604737, 14804355, 18900356, 1910150, 2000264, 255554, 46888907, 25999, 2655632, 9051032, 6186388, 47214830, 41829782, 189849, 1615261, 7697989, 2008480, 2557345, 7513506, 11666851, 550309, 51701158, 9594279, 7366056, 2476095, 9676204, 869806, 42534319, 42417, 21374386, 2590132, 10126773, 9655, 2237880, 21620791, 1975739, 3777981, 18228670, 28722625, 7079368, 26289610, 1179895, 4285901, 3745230, 2737741, 9681, 18089427, 992724, 37512782, 198105, 46491098, 35210720, 15958267, 280038, 3433959, 9704, 26161404, 12731882, 16940663, 6587885, 1181166, 26052082, 271955, 255476, 288109, 13642450, 19592788, 959994, 17916, 41516459, 17919, 8283648, 1576489, 1608104, 566788, 1050118, 566791, 27321864, 6997513, 1181194, 9201824, 10364429, 48793102, 161368, 7775763, 8807956, 402965, 3884566, 157207, 38258201, 1246746, 83483, 47665281, 38567954, 2147875, 24987172, 2647590, 16262696, 6768170, 29593863, 16901676, 706832, 9000541, 18294320, 9777, 1918514, 75315, 34457140, 411189, 24348214, 6972983, 7054904, 75321, 6481466, 10760458, 1754688, 13805122, 647435, 3425860, 9062707, 53790282, 13269943, 3319372, 18018, 21726090, 960079, 5310032, 1115731, 27768223, 22136406, 18687576, 26240603, 19572317, 2770526, 444005, 17524322, 35284579, 27051621, 43665000, 435817, 640619, 6391404, 28690029, 38987375, 25282152, 31377010, 7513716, 2401910, 454409, 26003068, 59005, 30860926, 19329301, 18540161, 24553093, 1386118, 2213513, 37643914, 7278871, 42564546, 15787663, 321168, 272017, 41081795, 591508, 50636437, 6465175, 3049112, 45188761, 33941147, 22176026, 14493343, 14968480, 9766562, 27551395, 48070, 23733927, 13257671, 239276, 5949103, 13182644, 30312117, 1851432, 21898936, 23922361, 157370, 20072123, 36447933, 2426558, 10145112, 1091266) 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...
