rest3/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 (3755436, 12496301, 20082094, 519599, 35958194, 7065011, 24235445, 51203510, 11703, 54160824, 22351292, 20786621, 372158, 3498280, 14347714, 2207171, 1789380, 52470, 2635681, 4402634, 437707, 20598220, 1002957, 19541454, 77265, 85459, 16002516, 5079601, 24948184, 6416292, 4566490, 24694235, 7228896, 1183201, 31378915, 454118, 14593511, 3722728, 3706346, 43683307, 12144108, 339438, 7728623, 8302064, 16576294, 4295993, 50949623, 6360568, 639572, 536058, 52448766, 25734658, 30567939, 22842884, 773637, 31329798, 43437576, 5705227, 40103436, 13489991, 1830415, 5983761, 10776082, 4689428, 2305557, 3067416, 48410137, 13774362, 12509108, 49761820, 14962206, 11685407, 3343070, 1660848, 31329826, 2207268, 3231269, 60966, 8244776, 1272928, 254359, 14749231, 13758000, 2092596, 34975285, 40316470, 446007, 22416953, 1052218, 3344162, 18976411, 29175050, 7466558, 532874, 2870848, 23572033, 1068611, 18771524, 20786758, 43200071, 23572040, 470602, 34655819, 18345548, 44301, 47738449, 34655829, 429655, 28135002, 2133595, 47853732, 1836986, 691809, 11601563, 33636966, 18361961, 142957, 5451374, 26793917, 54111856, 8981876, 34757907, 31034996, 25579128, 12963449, 14200443, 23449213, 5787262, 11903, 44437120, 5983873, 21294724, 39550230, 7088065, 36564616, 35688073, 8195723, 17378956, 69261, 42628177, 35696271, 3845776, 35466897, 18835395, 2289300, 11583561, 5738135, 12070553, 21106331, 2772637, 40496798, 11937, 85666, 1933880, 159400, 495273, 7696042, 49317831, 470701, 38250508, 26441672, 1994418, 40947379, 2444980, 26627765, 6364818, 22736567, 4411064, 26042348, 42446522, 31829691, 21311164, 159422, 8788475, 1609411, 145246, 11210437, 708294, 47762721, 21245640, 1003209, 2494155, 38589444, 7425741, 28451875, 18976464, 2352057, 222717, 50884316, 995038, 454369, 323300, 38180817, 41591823, 971388, 28093735, 3157740, 48467693, 10514158, 298738, 1756915, 7933684, 11055742, 6237942, 28176119, 1429241, 31559418, 21614331, 210901, 8173526, 2191110, 55193352, 13045513, 667403, 475588, 54488847, 39620370, 18563716, 143132, 24997661, 782112, 17927396, 3527408, 5738279, 43986730, 30535469, 921391, 2584369, 34033458, 5263155, 364340, 44519222, 6452800, 41615838, 5984058, 2199355, 36925245, 1077054, 1519423, 536387, 175940, 12160837, 46313288, 27366028, 3915, 24112972, 608226, 184145, 2661854, 2699093, 3608407, 4943706, 31764316, 9236319, 3034976, 8048482, 3214652, 35344235, 44908, 26627951, 39546736, 3755891, 6409534, 5418871, 987000, 225146, 17788007, 53118, 13094783, 1896321, 9842563, 13966597, 11333509, 642951, 29798282, 179522, 8662927, 315280, 45682577, 20993287, 23433111, 10270501, 458953, 38770945, 23089052, 13946781, 25005982, 34274629, 454561, 16625570, 208806, 13709225, 4059050, 37236652, 25751470, 4427695, 544692, 14643125, 5762998, 20598712, 24860660, 20913824, 724924, 29708221, 28430273, 503748, 3592134, 14192585, 30977995, 35811278, 1871823, 151504, 1183697, 179534, 13945124, 1467432, 52547545, 428026, 77791, 27663696, 28282850, 38678499, 11533649, 34795496, 6885439, 151531, 22163436, 7506, 21458926, 140891, 19156982, 19497641, 249851, 10366973, 847870, 253269, 1437697, 471042, 15863812, 35000330, 11145227, 23429805, 3706897, 495635, 2270233, 9211925, 3256342, 14823448, 27463706, 52809758, 59397, 19066912, 4083745, 6008866, 5709147, 46608420, 52031529, 40865834, 12302343, 15970348, 151597, 11561130, 20074544, 22499377, 35450933, 757814, 19673144, 4165690, 20539, 21622845, 1900556, 28799039, 7327072, 33304646, 6352969, 1552458, 7778379, 26964044, 22235149, 18711641, 32313425, 42774610, 151635, 32313428, 3108949, 405590, 25339180, 15323224, 233561, 3905551, 25514076, 2560094, 46714975, 512097, 3215459, 1372260, 42463333, 3797094, 45257760, 7098472, 1527913, 16252795, 25309293, 1773678, 1175664, 69746, 26683411, 402110, 11477695, 1994877, 40213976, 23507072, 1511553, 1806467, 31477892, 692357, 40251526, 675975, 14639810, 20298898, 7533, 19927184, 2093201, 7090324, 20630, 22933657, 2592924, 31314078, 6295711, 37589152, 37982369, 17862818, 2470052, 14340261, 28814705, 37318824, 8448028, 9343147, 30666925, 1183918, 796701, 6336688, 11932360, 44855475, 19384350, 6271158, 38974153, 2642105, 3502266, 3485883, 2416450, 7696573, 1272975, 4509888, 4289, 30699714, 856261, 39293127, 21090504, 27422923, 26028066, 7024846, 5394639, 33099984, 19337425, 24154323, 22745302, 21467140, 1069274, 35205339, 41963741, 990617, 54005985, 1790181, 20803814, 3035367, 1437934, 1256675, 676081, 21090546, 2153854, 5239032, 1014350, 962815, 545024, 741633, 35574019, 15405316, 7377157, 3846407, 16896266, 3682571, 930060, 643345, 2609426, 1023363, 2406446, 1773846, 6730007, 209176, 1192217, 3731738, 2397904, 6164765, 19575070, 5624098, 1512155, 11746686, 6541606, 29659431, 1167656, 12796636, 21401901, 45358, 5902640, 18514987, 45362, 24860723, 1401566, 24588599, 6287673, 12602, 102715, 14430524, 25760062, 316104, 1364288, 13209921, 3084610, 22090052, 407606, 43326740, 24637767, 1470792, 45385, 38285642, 27052087, 38023500, 8419634, 2081507, 21139797, 21565782, 18489, 50450337, 12637, 37097824, 13750625, 332130, 488166, 1756322, 5116264, 1891895, 239531, 36712812, 1134957, 43397486, 38203761, 13873523, 15339892, 1499881, 34689402, 665663, 32231804, 30511486, 15036800, 7885185, 463235, 10654089, 29066, 17543564, 31519117, 4075919, 41521552, 4833604, 610707, 16593301, 20283985, 7418263, 34482244, 27300251, 32297372, 3379614, 35140000, 23933680, 18715046, 14979497, 23232492, 5149102, 3895730, 5968309, 31576502, 33678068, 8950203, 2363838, 192960, 26505668, 10860620, 684492, 34385314, 21393870, 47181, 2068946, 36909523, 10858964, 152021, 32316424, 307672, 329807, 2773469, 11637214, 44962272, 67664, 28881547, 750057, 37261803, 4588, 36053757, 610800, 36721138, 5317374, 176630, 1225207, 1231233, 4633084, 1585665, 20612, 8027563, 26276357, 1225224, 33190411, 38441486, 30822927, 9631559, 4338198, 18716761, 475614, 41026308, 34845211, 1135132, 4638, 24498719, 1626657, 6296098, 11478570, 23400530, 24715762, 53572136, 651817, 6885932, 11014701, 3117615, 1167923, 35435060, 202846, 50143837, 32494138, 12860, 37843517, 15445429, 22688320, 9183379, 3404358, 14160457, 23278155, 471629, 1258062, 7869007, 25317968, 1716817, 10490452, 33604366, 13095510, 28693079, 86616, 41472601, 782939, 13202012, 512605, 2667102, 26825313, 12451259, 3617382, 3182012, 1176171, 2121041, 9465277, 16953972, 12767861, 78173, 8434295, 938620, 6115965, 3887742, 32068223, 32395905, 1864324, 3382721, 6425550, 12227209, 32871050, 43012747, 644743, 37817794, 627342, 48099985, 26079892, 24776176, 39121559, 8868504, 23532187, 20337308, 2044575, 24949408, 6378146, 54801059, 7115429, 43567217, 21189288, 70313, 31675050, 7593211, 25588398, 3044974, 31658672, 32458551, 33329842, 17192823, 8204980, 3584694, 3379895, 19804857, 9941691, 23032514, 18709, 201416, 3396297, 28562122, 36123339, 4764364, 21279437, 14178424, 7140050, 5571363, 2568916, 86741, 252705, 49197783, 1732875, 7295706, 36773327, 3404509, 2765534, 19391269, 8013947, 18314022, 1659622, 27972327, 5354216, 176873, 43651818, 8876777, 3257070, 21402352, 30372593, 168691, 46587051, 24761079, 29045496, 33272573, 25090425, 20727936, 19161899, 70404, 40538888, 15948392, 5673738, 520972, 21091085, 152365, 38458128, 10522072, 586514, 27592835, 6320919, 8135613, 34601053, 43340570, 18387739, 25056028, 2690522, 25568341, 38482719, 570144, 42537762, 47649572, 6304550, 21320487, 20419368, 4207401, 422699, 25752364, 37180205, 33518384, 19559217, 95026, 982494, 44710855, 36639544, 1954619, 5419839, 27603779, 340804, 1127238, 20181706, 889673, 12664290, 9851726, 37711, 39007057, 1702873, 21827043, 37263, 1561429, 488278, 2664234, 5157721, 25514842, 29184860, 496477, 2028383, 48665440, 33338209, 387789, 2962275, 37483364, 1700709, 21738342, 3158887, 5370728, 29779560, 4051818, 1520491, 22417160, 24376175, 48640880, 7451505, 22235283, 1348469, 406392, 177018, 43332475, 44938110, 1258368, 33796994, 1770762, 5043077, 217990, 365448, 1512330, 1405835, 6452108, 1373070, 16911046, 44477629, 8097475, 28752025, 3036056, 1659801, 16274330, 1897374, 70561, 34272070, 11129768, 6602050, 56088, 35877807, 2921392, 3429298, 270768, 46005, 816054, 32576439, 27947961, 24753082, 3052475, 586686, 3298239, 27487917, 1094594, 652228, 15707949, 45274055, 30225352, 381897, 385883, 36361163, 6525900, 21304272, 960636, 21244067, 32805710, 37114839, 1349796, 22877146, 39957327, 5911516, 652253, 50787294, 29194405, 43054049, 7050210, 300003, 30487525, 9425896, 22909929, 3085290, 21308576, 1764527, 18994159, 52311025, 36539661, 3634165, 2642934, 19216127, 20902905, 6231034, 10381482, 6378494, 299140, 13947908, 4183047, 5780488, 26399753, 95243, 47257773, 18568208, 4301656, 52958226, 152595, 2642966, 447513, 37688347, 4617244, 2782042, 40612894, 19066373, 1889312, 70691, 34362406, 34187441, 17092826, 1606492, 4106797, 1990393, 128044, 1773998, 29266993, 8950835, 13784116, 11051870, 13743158, 4024500, 19231802, 19720668, 17896511, 38958144, 29692993, 6485058, 3683400, 4650058, 70731, 435042, 15283281, 42083171, 5204, 23004004, 25482330, 250971, 43194, 26121310, 33551205, 5043296, 2479202, 2503785, 10515564, 11269229, 17241198, 29717616, 1135730, 988275, 19592308, 14981310, 10380137, 5043321, 10354519, 1644735, 21869692, 49525610, 611454, 10482817)
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...
