Count revisions per editor in 1000 pages - 1

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

select count(rev_id) as total_revs, rev_user, rev_user_text 
from enwiki_p.revision_userindex 
where rev_page in (66571, 35000330, 6732644, 986140, 31164649, 3777280, 9745203, 4271735, 46417772, 1271911, 39566065, 911940, 986140, 11055, 8918831, 286558, 18535888, 5371266, 4792698, 11937, 427854, 986140, 118445, 41342719, 44100, 7136716, 22361, 24310788, 9288617, 39546736, 4390719, 12504142, 8202363, 35068616, 2066658, 1485417, 43693303, 31118871, 346247, 334511, 32068223, 19605821, 1553589, 437707, 18723555, 6861934, 18424340, 59005, 28362121, 19156228, 79992, 45650001, 485213, 40370, 2590170, 1015853, 567387, 27272091, 570144, 1608104, 27684966, 24256603, 437707, 14879190, 38714949, 288109, 34425642, 19594764, 5968309, 14450701, 5783532, 8202363, 535443, 42596911, 175063, 35292712, 10848987, 5604737, 9242862, 82000, 47773, 488736, 31620722, 7591984, 22894937, 1579343, 31164649, 295771, 4824336, 48123, 37998987, 551882, 6481247, 42142539, 30046920, 1833614, 18661746, 5840841, 15087626, 947750, 19631109, 3987950, 4188015, 623458, 5342013, 13182644, 6692, 499415, 1134913, 6637319, 12610501, 21652488, 1597504, 52031529, 1485417, 3117615, 17896511, 106514, 5910715, 75321, 40713403, 21008091, 11818629, 1553589, 364340, 8407074, 3237302, 16959054, 18716060, 18716060, 33597564, 31920403, 1278223, 5625153, 15585169, 3915, 26015294, 20090470, 22361, 17958698, 23849770, 43517697, 3785735, 3433959, 2764950, 14658911, 986140, 15612792, 92620, 8411919, 570793, 4150398, 6271158, 1697096, 45095012, 2960, 5412264, 264699, 18346076, 75321, 5910715, 4588, 647435, 46336153, 12143633, 6244214, 3117615, 63917, 22745302, 13769, 39228, 15970348, 4963440, 15405316, 2781711, 22135613, 5157721, 647091, 16189, 13073289, 1024, 12075023, 4419763, 286558, 1715472, 17241198, 49405, 17089722, 27551395, 34800023, 584177, 6551, 75321, 9712896, 18935379, 5767921, 65428, 7933684, 17393, 15087626, 2025310, 20783872, 21245302, 168691, 11145227, 19041393, 2898178, 165624, 3706897, 1779773, 15342559, 2684051, 4421597, 15395558, 407141, 9372509, 2905676, 227507, 21809465, 4554485, 30741836, 49157716, 43683307, 34072957, 187786, 796701, 1405835, 2869458, 165636, 13598862, 15087626, 2337111, 32316424, 36718217, 5855584, 5351, 770398, 40422296, 986140, 46417772, 4199865, 40422296, 18716761, 34188215, 3174111, 25667320, 19391269, 42349774, 13094783, 3613138, 85236, 2349182, 16189, 12796636, 2584369, 13534401, 423345, 3366857, 49291595, 12382290, 3909935, 12195701, 28320640, 18212860, 10519831, 29256380, 43054049, 43758735, 32935801, 37075754, 3254980, 20598190, 639109, 50907389, 4926715, 3989724, 2272040, 5855584, 1278223, 83468, 1528090, 97143, 7606269, 1427918, 1352359, 5910715, 7657379, 18535888, 1501236, 29766512, 3252662, 13692202, 43605744, 724924, 28562122, 18691509, 323146, 46429, 43135846, 389807, 14593511, 2823542, 4848272, 299756, 47159, 1636467, 557711, 10519831, 66571, 2348132, 229024, 8943696, 33535767, 44855475, 17919, 46696175, 53026687, 6186388, 225668, 34313432, 3706897, 91220, 38705682, 11937, 551885, 5775903, 268442, 255554, 21402474, 18636805, 3489028, 23672747, 570793, 54345688, 51182473, 23041, 39271849, 85236, 19273984, 67448, 1259295, 222824, 36426399, 961803, 11637214, 21486694, 858516, 13489991, 205529, 2823542, 22576544, 384121, 34992247, 18716327, 11911886, 463843, 5603578, 1716817, 34482244, 149816, 46652721, 21402352, 53569176, 997752, 41453921, 8204980, 1246746, 1835444, 26045273, 92928, 15953267, 6473946, 21486517, 475614, 8753359, 35955576, 25303222, 3898071, 519409, 6437442, 1510878, 37425894, 464862, 8811944, 28035875, 7764658, 46587051, 845511, 570793, 40191363, 3361193, 390803, 14864, 179816, 45329621, 845511, 6342921, 450800, 707580, 49108507, 10046647, 1377270, 38430157, 18540292, 50729083, 3404358, 566105, 4141250, 20501675, 10732780, 3026760, 2432061, 456055, 8451090, 12368577, 197022, 43986730, 3680344, 5738279, 9372509, 1714725, 1644365, 1549514, 7713468, 40106231, 37084352, 4338198, 39023476, 10519831, 48970022, 3925726, 53541233, 475588, 29484321, 1382125, 5418871, 23042390, 10860620, 170241, 2584369, 18540292, 34977324, 26708798, 36956402, 30741836, 22318943, 1018302, 50052007, 36099327, 10111094, 1210567, 33269246, 32180002, 29025903, 986140, 327311, 29511655, 9756792, 7132562, 3022445, 37995227, 3646543, 10277049, 219041, 4783, 40977464, 44741, 43683307, 8663452, 9961419, 14113571, 6732644, 1279967, 3489028, 12127001, 1817, 622792, 75321, 1991823, 46873978, 19785071, 4700222, 9645904, 20805023, 23025, 75315, 389531, 458917, 16665786, 3608407, 18426524, 12163274, 21373594, 27322290, 28494488, 41422497, 1213398, 1040859, 1222521, 1623350, 38430157, 44559, 38771130, 1213398, 14491325, 3098233, 41157729, 13778, 2765534, 547856, 2323155, 37003885, 34234042, 2642105, 6818921, 2075287, 986140, 42742475, 986140, 4622916, 28383, 39694515, 754457, 10183560, 2868049, 222021, 1866855, 3835058, 299756, 43332475, 20019105, 287891, 3308371, 3706897, 32017191, 21402352, 1866855, 19559217, 1495116, 9577382, 37617889, 25439398, 986140, 2823542, 47774323, 425905, 19596909, 306341, 1518125, 503138, 46793470, 22581125, 53714969, 75321, 21184978, 4894, 31381832, 11477695, 10245848, 9543416, 37766375, 1833614, 1826296, 2397901, 15863812, 566428, 464862, 1803748, 1116229, 21304534, 33515331, 33625292, 16723805, 885614, 57981, 27735352, 982688, 15253621, 7785041, 34066886, 2584369, 1426543, 47624781, 45719, 29079416, 18973560, 2336532, 39297694, 2820604, 236650, 3196152, 6304550, 1437697, 24948184, 43407922, 3706897, 42793, 29278436, 14247800, 691809, 23900512, 725077, 7777393, 1260607, 570793, 19191056, 34750350, 1019067, 3691883, 43312100, 7764658, 72295, 75321, 16423, 25699058, 21255607, 51607340, 3382510, 2334628, 42853535, 22745302, 50787294, 3036056, 2397904, 2680619, 15983015, 39351110, 34305299, 44267625, 140337, 2517583, 6481247, 21337977, 5905358, 75321, 17442838, 313069, 37707147, 28338105, 1028575, 13743158, 56088, 39231098, 31407533, 1090067, 4514044, 7115429, 66266, 81325, 6177064, 522914, 10245862, 18535888, 75321, 15969457, 3770429, 29431843, 8988558, 7597447, 17210185, 10490452, 31890787, 45055767, 3117615, 389531, 50231084, 42125391, 7933684, 41568658, 150090, 5944, 986140, 3592134, 48445567, 6271158, 53969628, 38437162, 41348185, 54865, 29332095, 23296554, 2632034, 412341, 488736, 42232208, 3706897, 6877270, 606562, 1269833, 52344141, 9749991, 6422357, 37600962, 37031, 7640, 26349049, 172137, 334511, 852540, 7764658, 3706897, 46997678, 43312100, 2857, 3706897, 22845089, 15482939, 37344526, 8579532, 24981777, 986140, 3748416, 11000404, 940591, 37498043, 19354455, 33597564, 7211122, 37837239, 4152858, 1756915, 36238873, 986140, 41963741, 10349596, 1877734, 3372752, 245582, 76044, 3299771, 19521196, 317858, 6202326, 27487917, 5928780, 8661634, 2573683, 9898984, 3300203, 1763172, 2698130, 3117615, 45050511, 14723671, 47377795, 317858, 1917900, 553687, 2757487, 1437850, 2427796, 50412, 337215, 25829084, 39035675, 27033045, 19365900, 2831527, 3345653, 3809775, 36324651, 10172086, 22863844, 27667669, 5993109, 27663696, 19291482, 2229659, 28670262, 54352377, 6814593, 2025310, 3382510, 4545278, 570793, 6446561, 986140, 34707018, 21480370, 1200511, 313069, 19572308, 19402764, 3706897, 6384838, 3706897, 13750707, 15612792, 391243, 240572, 300691, 3345653, 36971471, 14539066, 4711148, 5157721, 23684128, 320554, 299987, 2773469, 13313193, 551639, 6658712, 5777093, 43397486, 7017294, 3792872, 1187707, 3117615, 2057698, 3380, 28752808, 3464855, 189815, 13456979, 2057469, 1902053, 1213398, 19631109, 33968, 22770653, 1663638, 31187755, 15221353, 21249146, 2135520, 17096166, 4576758, 3302943, 49317831, 7696573, 18715046, 1203587, 364347, 37996924, 18715046, 54111856, 955186, 3425860, 144373, 1278223, 33156578, 38806685, 5929168, 19593077, 20805023, 33284731, 4700222, 1440931, 10149920, 21167942, 23449213, 6284234, 24296780, 14933777, 608792, 24536302, 35935076, 1137231, 445245, 21132270, 5442203, 690923, 3706897, 499934, 6997513, 691809, 3176755, 188352, 816307, 8697581, 1751722, 1752026, 148395, 30991071, 65428, 1791636, 1003209, 550309, 1307704, 2302831, 42417, 1264559, 81293, 288109, 34833353, 17035648, 26810058, 1261827, 433351, 1877162, 21093109, 4051818, 1063053, 20245805, 21920673, 433583, 3315639, 4214323, 1261827, 852504, 15299, 32857971, 31302654, 639109, 981526, 7029518, 34284572, 570793, 50391221, 3884566, 5417391, 525312, 30046920, 1445633, 2823542, 4669926, 52756614, 1405835, 986140, 13812515, 38985010, 418643, 2234301, 317858, 52547545, 19804857, 1213398, 6732644, 2100637, 38714949, 31028735, 17527725, 48684489, 12520482, 12197038, 51607340, 3706897, 313234, 41911471, 29362, 7696573, 2584369, 47519278, 971388, 385001, 21402352, 38270155, 986140, 15623696, 19008856, 32969, 690923, 22361, 9842563, 606705, 4155638, 72698, 986140, 11666325, 4590086, 2272040, 986140, 14695, 52765664, 1188838, 606776, 1443469, 4252797, 1145077, 69727, 1052218, 8019326, 3945047, 11395, 16002516, 35258296, 47722817, 7933684, 2609426, 10492110, 239531, 3231269, 54226227, 4700222, 2464967, 51058041, 223843, 5179753, 49761820, 1278223, 6395924, 22361, 21090913, 46391155, 26353494, 168691, 16695580, 43529737, 1447059, 25882980, 2334628, 1659622, 21655013, 15299, 2770526, 2517583, 37498043, 503138, 118445, 24928187, 2647005, 1592975, 13165, 7484647, 12535530, 17757682, 198327, 1553589, 26269565, 294332, 233561, 1553589, 32628097, 456362, 36184596, 21615697, 363032, 52547545, 30977995, 5713977, 1553589, 22379950, 40529722, 3489028, 3364087, 37644001, 41342719, 37048140, 46359, 689924, 1648322, 38742, 27963105, 570793, 3083803, 3883573, 1981971, 32897239, 35605058, 165636, 13182644, 6237942, 198327, 14823, 7039000, 18973596, 12106325, 20956911, 2129225, 27124711, 40108212, 44588822, 1637601, 570793, 26793736, 4638, 83020, 34112310, 1723329, 2584369, 21278825, 29027288, 33555201, 623458, 2062768, 1316814, 12584132, 20324607, 389617, 4599013, 3706897, 1669311, 17829687, 7324352, 254359, 20125715, 13042467, 2823542, 33129653, 18763021, 986140, 300691, 509767, 3850406, 5910715, 4850889, 15945001, 21234261, 46347823, 1023363, 31816539, 40370, 3382510)
group by rev_user 
order by total_revs desc;
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...
