rest2/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 (37643972, 54118085, 26134215, 38938312, 4811123, 30557900, 29126946, 4338391, 54281935, 6276816, 6792913, 15599315, 10648526, 26248919, 39331544, 16287084, 3925726, 36488927, 39118561, 231138, 37521125, 419558, 23520999, 12535530, 8873707, 444140, 3689426, 20956911, 1271536, 47589105, 43149042, 19180499, 37644021, 51431158, 165624, 3794682, 19375868, 43517697, 165636, 18040581, 8087302, 27883137, 2000648, 29976329, 2829633, 24774415, 35571475, 22677270, 228313, 198424, 24291097, 36620059, 23037726, 4818565, 47441697, 49366818, 2557732, 1025831, 24995624, 42793, 17958698, 38537003, 8951432, 3423209, 7128884, 30278648, 36718217, 6539064, 26658617, 182076, 52913984, 6563650, 11593539, 39102277, 20473670, 509767, 13701, 26740553, 5375818, 23603019, 41959469, 427854, 45305965, 255824, 34896857, 18483028, 1470777, 1435480, 21026447, 21280402, 485213, 2025310, 44017503, 1704009, 13199201, 1337187, 5932689, 33285994, 34875244, 1566573, 4188015, 42174320, 981992, 27633522, 5910715, 6244214, 6711159, 1222521, 7879658, 39208831, 10366345, 20800, 1247106, 33531779, 51857285, 47722817, 41674632, 27961225, 27486091, 1779596, 13387661, 5784, 41035666, 348135, 30741836, 11470745, 5680111, 7273265, 25716963, 3475363, 25126820, 22620069, 17657823, 43354023, 52742056, 3322183, 47179693, 83886, 36860232, 4286386, 32558067, 2647988, 6686645, 40656936, 518074, 52029374, 5507009, 6825922, 296899, 983447, 24528839, 39626699, 15149005, 15247310, 11052707, 11020245, 22046678, 46345209, 206814, 1279967, 26068962, 32807931, 19102576, 45025256, 44115945, 43345899, 13567981, 15198192, 53587, 468983, 75770, 3639291, 2138453, 2048, 1673221, 4140907, 149516, 1116173, 6563854, 853605, 49445719, 2828307, 17442838, 12937239, 7039000, 10468356, 1468444, 26298397, 22579230, 428063, 8407074, 12707879, 7948330, 48811015, 6383662, 1057117, 3016753, 100404, 19376181, 11241527, 22882361, 50046933, 14714939, 40749116, 1779773, 3786421, 665665, 22071364, 29535052, 3531734, 51693643, 29026383, 4622916, 44304466, 6411961, 567387, 3303098, 290039, 26445921, 48711778, 3984060, 59492, 3625052, 54831207, 38103151, 5908592, 5793905, 10020978, 1878132, 3147893, 10111094, 12462199, 5664401, 8202363, 33597564, 1230973, 28977278, 25515325, 12839040, 174210, 403587, 25282694, 346247, 13062508, 10379, 22603916, 47209084, 157838, 41183378, 7456915, 33390958, 19351702, 1173657, 53438618, 36544879, 149662, 30222495, 38889632, 2274534, 18892963, 11364516, 23390374, 43206823, 149673, 19220650, 35842219, 22497452, 20220077, 20278301, 9177265, 1894578, 10946739, 9709748, 13322421, 43976888, 706745, 47294650, 1149117, 8718527, 32917698, 10209475, 39495877, 11626694, 28059849, 30410954, 3713227, 31967436, 5610530, 51406, 32006520, 6007843, 35981524, 944341, 2238678, 2296025, 3015686, 1484285, 6580444, 1460445, 2279646, 6023391, 15100129, 1698018, 14803323, 10635492, 6850790, 7571687, 31164649, 27691242, 1775314, 26864, 24742129, 764146, 11533, 1239286, 12421367, 9136377, 18721018, 22823295, 2301, 26878, 13608661, 3787014, 23759111, 36907272, 76044, 2115853, 8538382, 6422747, 51808528, 43419922, 39807252, 37423381, 41167127, 1386778, 36210972, 10525, 12962082, 2337059, 706852, 33884453, 2271530, 1520295, 32229678, 149807, 551218, 31721, 2033972, 739637, 5933367, 45574456, 42043706, 46653834, 31984693, 9985411, 164235, 411973, 993606, 27117895, 4000073, 158027, 43340, 166228, 20781945, 17058134, 5069881, 45388090, 29182303, 21479824, 166242, 22530404, 4155749, 92518, 1902951, 54118760, 6195562, 2000615, 17058158, 2763120, 48064881, 1599858, 31893875, 44910964, 12896629, 32696694, 39272096, 19360120, 23316858, 482367, 15868309, 44886400, 2738561, 649603, 21916036, 30443910, 22735240, 37628298, 7489931, 34596589, 42232208, 7039377, 20015506, 764307, 149909, 26610070, 7195031, 31864135, 11217305, 4778394, 46696175, 469405, 13085086, 34227952, 389531, 6556068, 154477, 36858280, 33753513, 21285293, 1297436, 428464, 2202696, 739762, 8620467, 272820, 3387806, 8047030, 49296521, 18536180, 7612860, 11487677, 1018302, 1001920, 32786881, 6351298, 43154507, 31779268, 2201334, 50561441, 41273800, 47745481, 21359051, 584141, 15321550, 2066895, 21285328, 862674, 1624532, 6511694, 31771094, 2501079, 30509528, 2410969, 4942298, 182748, 3234896, 36219363, 4180452, 3961254, 10726, 4680170, 5294573, 272878, 17369587, 41044470, 18499687, 3598483, 264699, 51709, 3844608, 6277634, 50039302, 6294023, 7670280, 13888009, 657931, 903692, 780814, 1034767, 2133080, 25119250, 33871491, 1421742, 47581718, 363032, 689924, 19868186, 44935708, 387615, 30714400, 15755809, 10529314, 8392786, 1714725, 4278823, 7604778, 44468779, 54241837, 29567534, 18082909, 33412872, 4811315, 173833, 26542516, 2271802, 4860476, 21477130, 53684799, 1845825, 34712130, 420420, 3252662, 84552, 608841, 150090, 1637601, 3197517, 2517583, 1049016, 52972115, 28904020, 17246807, 51980889, 12151386, 27155999, 6212188, 3689056, 2648673, 223843, 8456806, 1499574, 1485417, 14285927, 24406637, 4389705, 33868400, 16238355, 92654, 23030393, 47032954, 215675, 13355644, 3779198, 2462144, 20957827, 27757188, 24151830, 3230346, 36626943, 68237, 141966, 26896152, 150162, 1665685, 912023, 25438872, 1704388, 5442203, 18426524, 22353527, 305825, 36054811, 18072006, 37047409, 2861739, 12249773, 7146158, 1510063, 24344294, 1002162, 346804, 6474421, 5900984, 256697, 39332539, 20368060, 4660341, 425905, 7629507, 3254980, 30337734, 37292743, 1411784, 576202, 158411, 10562252, 3402445, 5180113, 33008338, 1521443, 27691734, 49273977, 4991706, 6210363, 4156127, 17451745, 35859170, 22744187, 19733, 19729125, 7129830, 33233, 142057, 6351596, 42298094, 15280879, 10423025, 9946921, 35793656, 3697402, 1330303, 5794556, 1903357, 34597630, 16829183, 54467943, 25594630, 11117462, 52292360, 12208905, 4377354, 35662605, 7301902, 46345347, 264982, 37391131, 27420, 30695898, 150304, 3662200, 22637346, 3230501, 19491622, 13011751, 1035048, 2857, 34425642, 51027967, 3640387, 11055, 2968369, 47162773, 17225523, 1878836, 8424245, 14863158, 1993527, 346936, 281401, 3690476, 2805368, 445245, 24431423, 6867777, 15185353, 142147, 24275782, 1171937, 478024, 36588362, 42142539, 28822348, 26553165, 34368335, 44624720, 26012505, 35965786, 2681691, 20966238, 4369247, 36096869, 1876568, 1210172, 4221803, 44247916, 27501, 16856893, 21441392, 3279729, 19806089, 15923006, 26708854, 18293166, 3271544, 3730297, 12979067, 30911357, 6303829, 237175, 168427, 31796102, 26012551, 387976, 47010619, 47917963, 45549378, 2214798, 2960, 887960, 29043602, 535443, 20147092, 3058581, 2174955, 40422296, 4017050, 7318428, 40586141, 2206624, 27388834, 4500635, 30672626, 12381094, 2214823, 5163945, 33033130, 3336007, 21384108, 7500274, 32028379, 10161077, 232374, 8095561, 371640, 11421295, 240572, 158653, 5876672, 1723329, 23014340, 40184773, 15616967, 31840076, 33999819, 551885, 2485198, 1782042, 19327953, 2149330, 3738579, 304974, 175063, 29027288, 32787421, 23006174, 2894815, 10546144, 39200592, 30141411, 466086, 6155239, 9898984, 26962921, 36229166, 879596, 43530066, 1335805, 25013233, 502771, 1264629, 183286, 842921, 43083604, 475647, 19729405, 442880, 41561091, 9951062, 31936934, 1084425, 22745800, 48792166, 42850690, 3804175, 1993744, 37047313, 27364370, 44010670, 486575, 986140, 551965, 43625503, 3320864, 25521185, 7040035, 3804196, 20130853, 1559590, 11441, 2010155, 30091016, 34171957, 47017014, 1835444, 4345036, 101556, 3902522, 4142943, 1567805, 1477695, 1723817, 2165826, 39414851, 601156, 36367430, 3869767, 1100873, 6061792, 2397703, 10751059, 3279957, 2149462, 18078905, 31042648, 4263002, 1263361, 44928093, 12840030, 23039072, 978017, 35081315, 3337319, 10243178, 51022955, 31255660, 766482, 12987581, 666736, 7777393, 30556691, 1027188, 11324534, 306295, 5183128, 7163001, 31911034, 27771, 27896956, 546666, 5139582, 172565, 3200, 1475606, 11395, 4674070, 2264198, 35953857, 46417772, 5368973, 2250605, 1911952, 3670552, 9538706, 31403156, 1285354, 42675351, 20434072, 5938372, 6032538, 21105819, 17179162, 7597216, 36531362, 27488795, 1821861, 28683430, 7400616, 11254983, 13440882, 740526, 543919, 699568, 15969457, 32328882, 15248563, 9522356, 14269946, 7277769, 16665786, 1019067, 36768957, 27544767, 371905, 41516235, 9022936, 50737217, 6384838, 21531744, 21187785, 37529463, 322764, 29191380, 24095958, 87930, 2772195, 396516, 4599013, 49065190, 18716327, 11343771, 11390190, 13698941, 23104754, 1304829, 85236, 355573, 21654774, 26758391, 27659515, 1051902, 42125391, 6274927, 19156228, 50752773, 46656774, 34975467, 45698312, 6507786, 18763021, 4214034, 295771, 10046741, 43249300, 191769, 1486106, 6351940, 10194206, 14213, 39005473, 31102229, 4140325, 52464934, 3525927, 15945001, 13692202, 17878317, 48876847, 12666760, 1191219, 29879607, 12545337, 2772283, 36426399, 17100093, 3583294, 44641599, 37293377, 101698, 40126347, 1035588, 945479, 22017932, 21933391, 2108753, 32373987, 609621, 19008856, 21802329, 3640669, 1501236, 6431156, 503138, 41974524, 5074278, 982688, 470377, 1764715, 313234, 3272046, 2133361, 2846067, 3935604, 23883125, 42988730, 7392634, 3231100, 38899069, 54545791, 380288, 24325505, 47377795, 1618261, 7597447, 863625, 511371, 49270158, 2354575, 37571985, 17952147, 3313049, 46648730, 339355, 1641885, 36633717, 11677088, 740769, 42241442, 13490075, 1199524, 6458793)
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...
