rest 4/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 (6805553, 95368, 35189897, 12186762, 38114444, 37853378, 18109997, 43758735, 4773009, 3413138, 1447059, 3208341, 283797, 35570743, 668827, 1236506, 39482526, 9809435, 30241955, 3101860, 1890502, 15766698, 1210567, 965297, 6927533, 390318, 11000404, 160946, 1553589, 12481718, 398520, 54457, 25138362, 11424955, 17790140, 20857128, 37524674, 1774787, 18232516, 34411718, 382151, 1053898, 33625292, 5756691, 21132152, 39490770, 160981, 29480153, 49624963, 9820367, 10114268, 27167407, 1340639, 21320929, 1365219, 36000996, 14849254, 7484647, 13620456, 30528748, 6673646, 454184, 8172786, 9467123, 3273972, 7721854, 480502, 7165175, 18716060, 11121916, 14677246, 39416704, 1242370, 3650820, 39179526, 18506625, 3560712, 23080308, 611594, 17601805, 677134, 185616, 3749137, 34305299, 39703828, 169237, 161047, 28669209, 9909530, 15777327, 898333, 4732190, 51377439, 17454369, 6452514, 4035875, 2487589, 185638, 37229863, 5417, 19097634, 1817, 652589, 4180189, 431411, 30008, 23393593, 8491914, 27792702, 32396608, 1897794, 29823883, 6976836, 22097462, 20965601, 38925641, 22961377, 33568076, 18994512, 13923665, 4322643, 41891157, 9876822, 521560, 49755482, 44586331, 18994525, 3618143, 14247613, 849251, 5305701, 37048140, 3210812, 25204074, 26015083, 19240079, 37909394, 31987056, 4519281, 8370787, 31350334, 2823542, 456055, 34280825, 12391802, 40129915, 6301930, 48985470, 8754561, 23729541, 1040622, 5354887, 11638153, 1045898, 43226508, 7538270, 1258894, 26949007, 32126353, 144789, 19223959, 365976, 1269441, 1234332, 13066117, 28833184, 1566960, 38155682, 570793, 51877290, 26629547, 22812077, 5905358, 423345, 18691509, 12113338, 4732347, 2569660, 3493450, 1029566, 366927, 6723010, 52415619, 161221, 38073798, 939463, 13374921, 21962, 26871, 25275941, 1119694, 2119119, 18535888, 21329362, 415187, 5707222, 37729752, 20297178, 36730331, 24196578, 33395859, 48399270, 36804070, 29896605, 3233258, 50907389, 2679720, 10155508, 3345319, 21090913, 2612513, 15382012, 31741438, 153088, 27334145, 3572651, 11499015, 43529737, 29335873, 431631, 49010192, 456963, 2843566, 17649217, 27821550, 1700783, 20461084, 28144560, 32304731, 19443291, 9016869, 947750, 15423016, 40825604, 2529330, 4011565, 46347823, 7534129, 39122482, 8836659, 8721975, 5396025, 33461820, 530698, 6346302, 53941823, 42136229, 1881665, 8314328, 7353925, 13514310, 39261767, 10507848, 3085899, 21968462, 30287, 292432, 9803346, 32544340, 26380558, 38220729, 20502104, 37590617, 39581274, 1750621, 13918, 30303, 1554017, 911944, 4634212, 407141, 25892454, 30881383, 30406248, 579178, 11646572, 20903534, 4535919, 18577010, 11384224, 210548, 11720310, 4265591, 4601464, 9098175, 6043261, 4863614, 19613973, 27981440, 7599745, 22623875, 11818629, 3593863, 24229512, 980618, 4375490, 11220623, 25163408, 18249361, 18855570, 300691, 14431892, 972437, 390807, 5093016, 39138969, 2348626, 22419485, 10770079, 29335152, 10344098, 3904622, 456362, 21481757, 1185456, 8287921, 47519410, 50484918, 4015049, 44166772, 15775419, 2496188, 1188810, 5387968, 5827, 44472005, 14276295, 29660872, 36255433, 26810058, 39950027, 5342942, 492493, 333520, 26621649, 1644242, 37689044, 7019707, 7020153, 10245848, 6514980, 1234651, 35075804, 349919, 52410081, 28178150, 18536171, 1324781, 628462, 41613040, 2373362, 7984883, 6190836, 37687861, 11884278, 35092215, 26187512, 3340028, 3848066, 41342719, 29685505, 8506652, 47520043, 11351812, 6202326, 7640838, 43661063, 26793736, 2472236, 8705802, 366348, 5437197, 4855566, 10098447, 27096848, 8080514, 11622163, 10008342, 52320025, 10573594, 45651740, 24483614, 3692323, 12859172, 43415333, 20111127, 603948, 8550706, 8918831, 10219144, 15255859, 31651638, 22353721, 4101946, 505659, 50526012, 40926858, 18372414, 51083573, 5577751, 12551136, 563010, 28784454, 4110151, 50706248, 2520905, 43194679, 5928780, 36639714, 10187, 18847570, 463843, 14268246, 22361, 28047194, 413327, 4530571, 1407484, 7886686, 2266749, 27866976, 51014076, 1251173, 51476327, 2652008, 35371324, 3331946, 25155437, 102711, 1349490, 30963571, 19593077, 21541865, 186233, 2930554, 440187, 28456828, 19117034, 34453374, 5127829, 7567233, 25114498, 34363267, 18978693, 8296327, 2406280, 37509001, 21337994, 751499, 35190668, 2889614, 2409416, 11081621, 751511, 8026010, 2163695, 5453725, 7534494, 6813599, 219041, 489378, 7657379, 66545, 53254056, 2054057, 1218474, 19765163, 42988817, 44636078, 52287407, 23041968, 44317000, 14882738, 18085811, 15947701, 3782582, 21552476, 145337, 40089532, 2234301, 1160181, 1687004, 54337184, 6879170, 42833860, 21510088, 7903179, 341964, 47708109, 1316814, 66552, 6977870, 31223070, 1423319, 25113927, 1579343, 464862, 12785631, 776160, 24764014, 7862243, 497636, 4044773, 3454950, 32937970, 251891, 48453620, 350197, 8984566, 12589047, 20789425, 251904, 9254913, 40130562, 21968900, 9902422, 17815559, 6559753, 15087626, 47051643, 9730060, 118445, 5830674, 6395924, 800790, 15374359, 3430424, 46594073, 55324, 2881565, 10721310, 4971470, 15079458, 29431843, 74758, 5440853, 9287720, 229864, 38688812, 36048562, 2545710, 36780079, 448561, 12859442, 45643827, 104500, 2308150, 2782217, 21641272, 8878137, 14291679, 4700222, 33642559, 27064672, 505922, 1369099, 44559, 6218, 5486667, 6420556, 20920397, 6486095, 8943696, 1169489, 30685266, 79955, 1685588, 23443541, 36616279, 19803596, 5675097, 20972559, 53426268, 25786461, 1013854, 44267625, 8451090, 3749998, 36010095, 1636467, 866422, 6322295, 79992, 12286073, 31620718, 25577834, 2349182, 9296000, 9205889, 538754, 41789803, 9634069, 6435862, 29767814, 65217, 52787337, 1063053, 416109, 7641233, 30537875, 29447355, 19773590, 25188503, 9083033, 11606170, 30472349, 202910, 8683205, 11098273, 47880356, 69318, 35666086, 53029233, 27703465, 44578986, 14585543, 4429996, 43268269, 22730929, 42576243, 18634933, 25303222, 2305737, 25659764, 4479166, 2595007, 6830273, 293058, 42025904, 6949238, 3406022, 19544263, 1816777, 35682506, 40892791, 30168321, 6535373, 10492110, 34019535, 5929168, 2570451, 34363605, 4686888, 33454302, 42116789, 63712, 3419856, 1317090, 8522107, 399588, 21659345, 882922, 51599600, 27982065, 309490, 21438163, 1054965, 20075561, 20166905, 19544318, 4421472, 4449323, 42998023, 473354, 14301451, 19161144, 10352909, 36518158, 52181266, 14100867, 7747862, 18675991, 1128728, 1812868, 34915285, 13997776, 55308, 7289118, 63877, 17456, 6209243, 48970022, 28451889, 23066920, 2174684, 5109377, 6805895, 2200565, 25467183, 51075377, 41589042, 3176755, 37477637, 24918325, 28670262, 629047, 153213, 39228, 2950358, 50190657, 25733515, 36133188, 863969, 55624, 9558346, 4738175, 24574286, 23263567, 48519504, 39377233, 29342094, 23042390, 54770007, 18807128, 2423129, 317839, 20461918, 5855584, 3372752, 47487330, 46365028, 14695, 3496296, 15128939, 13375852, 362898, 4696986, 34797936, 54401393, 3438964, 484133, 27096759, 18848119, 997752, 301433, 22337914, 35748219, 21035388, 4077952, 22770653, 915843, 674198, 2357639, 2840968, 4321004, 4228745, 1684546, 6474658, 51224301, 739736, 32340370, 1832498, 4091630, 6551, 10451353, 21125532, 694686, 317858, 9943459, 38279588, 50993575, 473513, 40860074, 63917, 4942237, 5044657, 51296691, 1571252, 2849205, 37837239, 163343, 52283626, 38771130, 63931, 39369148, 1046974, 23321026, 29490861, 32561607, 1038792, 2472393, 37050827, 113101, 31840722, 25516500, 39381, 20330967, 23257221, 53423866, 51468766, 15333857, 35330530, 5553915, 866788, 18840037, 530919, 27531752, 899561, 9488808, 24164851, 35445240, 145913, 3258874, 7027195, 10435068, 24697343, 326144, 9821952, 22518275, 7035010, 5735914, 47463016, 1063434, 33470988, 793101, 5675735, 51974487, 14864, 362750, 3185170, 5667347, 11895995, 19592281, 5960793, 6680, 31054361, 40958492, 6686, 100784, 12847350, 13502139, 66652, 44309036, 36690477, 37485102, 4479537, 11786807, 31288, 1784379, 727616, 64066, 1030724, 8813126, 21469768, 2285324, 162380, 23206478, 28817999, 18913720, 2439763, 653908, 12106325, 2128470, 47703, 72281, 21281370, 547419, 129628, 17250912, 4700770, 907707, 1528599, 72295, 5388904, 3676777, 5347946, 32402776, 1342061, 8575599, 47774323, 33217141, 47905399, 36780667, 32938620, 7789182, 6380162, 3988100, 23599749, 7326145, 3865224, 857196, 9288330, 45055767, 334476, 1833614, 3734161, 19290771, 293525, 391831, 6658712, 277146, 11188892, 47773, 34011808, 30898849, 383650, 42171045, 391846, 10795688, 2298147, 1751722, 1850027, 45290610, 23214, 334511, 776881, 7764658, 1559998, 3381944, 41138874, 3365565, 5487296, 38337217, 47979207, 326344, 5741259, 506573, 3191511, 2161359, 21330644, 1427918, 1768151, 32373464, 40314039, 8444636, 9247453, 998110, 318179, 32698150, 43008998, 9140597, 43899628, 338386, 8750205, 350960, 39566065, 4913908, 21093109, 8420088, 24709588, 473851, 6675196, 4545278, 33766143, 23468800, 4528897, 9703377, 6917, 252678, 35257095, 498443, 2075287, 3185421, 20650766, 18627343, 4152080, 14678804, 19331863, 50428696, 417837, 405942, 39708, 416541, 432926, 9681697, 3504931, 424741, 16988966, 25082663, 21175080, 14457641, 1940267, 310060, 269101, 13351727, 113456, 10386225, 9927475, 23911222, 1366839, 3463993, 5307195, 3054401, 154438, 26434376, 17210185, 5606186, 19635020, 293709, 3480398, 38966397, 441322, 7551826, 5634902, 5045079, 461284, 1991823, 179036, 3793274, 28236639)
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...
