Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
mosteditedtalkpages2016_startedin2016_morethan2editors
by
Galanben
This query is marked as a draft
This query has been published
by
Galanben
.
Toggle Highlighting
SQL
SELECT a.rev_page, num_editors FROM( SELECT rev_page, COUNT(DISTINCT rev_user) as num_editors FROM revision WHERE rev_page IN (5204, 11055, 11937, 13778, 14695, 15299, 17338, 17569, 18078, 20139, 20539, 23025, 32701, 32805, 49394, 73130, 87385, 88769, 101556, 142929, 152570, 159422, 195261, 228313, 231138, 238633, 240572, 261267, 281732, 287726, 293525, 298738, 304832, 304910, 308780, 313069, 318353, 322764, 325382, 356384, 380288, 390807, 400832, 410025, 424884, 441322, 443319, 446136, 454409, 487228, 509767, 549234, 554551, 570793, 606776, 639109, 674033, 684021, 690923, 706709, 748631, 857196, 909593, 947671, 951426, 1019067, 1057188, 1080842, 1164631, 1196798, 1247156, 1421742, 1532487, 1533258, 1542754, 1644793, 1755910, 1779773, 2001964, 2064661, 2338073, 2569660, 2570887, 2673336, 2739325, 2787189, 2827363, 2894228, 3123428, 3196152, 3433959, 3502266, 3522185, 3628779, 3633733, 3683400, 3902394, 3925726, 4015049, 4140325, 4216258, 4302197, 4345036, 4396468, 4570236, 4778394, 4958625, 5030553, 5074278, 5183128, 5220339, 5330946, 5418871, 5429869, 5451374, 5517847, 5790563, 6020794, 6046628, 6303852, 6322295, 6470706, 6652015, 6779223, 7127061, 7619174, 7673571, 7777393, 7891984, 7961483, 8212315, 8781956, 8918831, 9422582, 9629125, 9637900, 9794233, 9828639, 10122004, 10264889, 11010331, 11129768, 11746627, 11845498, 12108468, 12291454, 12315070, 12382290, 12751600, 12767261, 12796636, 13050083, 13489883, 13834565, 14678804, 15087626, 16556487, 16575210, 17822303, 17958698, 17959051, 18218977, 18426191, 18568208, 18763021, 18820542, 18967720, 19544263, 19729380, 19797446, 19909017, 20213852, 20411885, 20913895, 21105819, 21246702, 21986912, 22504887, 24082022, 24348214, 24794124, 24897105, 25005982, 25382865, 25911844, 26031859, 26033897, 26364735, 27691734, 27768223, 28236639, 29448377, 29685505, 30052927, 30530177, 30980172, 34305299, 35252511, 36017454, 36059083, 36201487, 36365108, 36578768, 36780667, 37837239, 38326555, 39340155, 39497784, 40064351, 40130562, 40633155, 41478827, 41631754, 41737359, 42189336, 42410872, 42455096, 42742475, 43326740, 43499874, 44288867, 44336339, 44466663, 45698312, 46209139, 46350456, 46525894, 46575519, 47013716, 47151710, 47197252, 47325214, 47570328, 48410137, 48445567, 48825663, 48970022, 49273977, 49445719, 49713387, 49761820, 50012895, 50023797, 50106865, 50230847, 50722484, 50788572, 50993575, 51025238, 51075779, 51198898, 51296691, 51462332, 51526688, 51675890, 51766618, 51807243, 52017882, 52034540, 52055021, 52124224, 52226886, 52231344, 52231574, 52233913, 52255686, 52268622, 52283626, 52292360, 52311025, 52396723, 52410081, 52431402, 52464934, 52547545, 52548514, 52639669, 52640183, 52673347, 52684722, 52686835, 52696737, 52742056, 52742452, 52757798, 52763633, 52772586, 52780652, 52785113, 52787337, 52791282, 52793497, 52801608, 52810212, 52813356, 52814257, 52847020, 52848125, 52851824, 52856509, 52868510, 52873734, 52877883, 52880995, 52884762, 52887197, 52888311, 52901996, 52906093, 52913984, 52920666, 52924258, 52929425, 52930150, 52930531, 52951078, 52951854, 52952393, 52959988, 52961701, 52963352, 52963692, 52963876, 52963989, 52964217, 52964418, 52964626, 52968588, 52974159, 52975382, 53013668, 53014004, 53016276, 53019623, 53029233, 53040245, 5204, 6919, 11055, 11937, 13778, 14496, 14695, 17919, 23976, 25075, 30328, 32562, 55324, 57981, 58566, 63931, 75770, 88769, 97794, 113675, 142147, 148582, 156530, 159422, 167392, 186181, 197022, 204674, 217996, 228313, 231138, 240572, 293425, 363739, 374512, 411389, 413840, 424884, 443319, 454409, 463843, 490847, 507998, 538754, 554551, 570793, 597743, 597747, 639109, 658407, 660043, 690923, 724924, 733580, 776160, 856553, 922373, 947671, 959733, 990981, 1009130, 1009643, 1035201, 1036532, 1038792, 1046176, 1072286, 1113794, 1121830, 1155822, 1158015, 1415317, 1421742, 1473865, 1631100, 1755910, 1779773, 1781516, 1850027, 1943022, 1951998, 1966176, 2121041, 2271294, 2338073, 2357245, 2570887, 2628937, 2662865, 2679720, 2698130, 2751213, 2894228, 3031187, 3045169, 3198728, 3339283, 3365565, 3433959, 3628779, 3683400, 3706346, 3722310, 3748416, 3777981, 3815720, 3851163, 3857308, 3959619, 4015049, 4191145, 4450526, 4535919, 4665357, 4666297, 4816311, 4826754, 5030553, 5346986, 5451374, 5666468, 5886420, 6322295, 6416466, 6601531, 6644289, 6807171, 7016046, 7046449, 7365077, 7418263, 7439528, 7569712, 7777393, 7809892, 8086678, 8322640, 8456806, 8764058, 8877260, 8924294, 8984566, 9006224, 9211925, 10378287, 11000404, 11081078, 11129768, 11845498, 11985477, 13029949, 13094783, 13116060, 13355644, 13805092, 14728900, 14949703, 15440814, 15949727, 17030847, 17958698, 18218977, 18517459, 18568208, 19443773, 19575070, 19595608, 19605821, 19685542, 19729380, 19849104, 19909017, 20618787, 20975467, 21829960, 21986912, 22356665, 22502482, 22619948, 23080308, 24794124, 24973891, 25015068, 25350089, 25568341, 25668579, 25692552, 26124317, 26743196, 26768314, 26788425, 26881414, 27768223, 28020865, 29146821, 29278436, 29488039, 30822927, 34171957, 34193280, 35252511, 36059083, 36201487, 36365108, 36780667, 37318824, 37416761, 37837239, 37914407, 38046986, 38326555, 38705682, 39019613, 39279861, 39781934, 40064351, 40289691, 41033318, 41535405, 41631754, 41688779, 41981088, 42458820, 42757079, 43499874, 44288867, 44616868, 44642941, 44795950, 44843504, 45165812, 45698312, 46229174, 46350456, 46474372, 46575519, 47325214, 47905399, 48124287, 48410137, 49273977, 49411733, 49679084, 49761820, 50106865, 50341283, 50406364, 50771435, 50993575, 51223718, 51282705, 51618648, 51759484, 51774205, 51966041, 51991402, 52019513, 52034540, 52226886, 52231344, 52268622, 52283626, 52311025, 52396723, 52431402, 52547545, 52600792, 52639669, 52684722, 52686835, 52695762, 52752710, 52763633, 52778938, 52812474, 52868510, 52881504, 52951854, 52966635, 52968704, 52987279, 53014004, 53029233, 53036111, 53040245, 53041473, 53053765, 53073358, 53080468, 53098016, 53107035, 53108370, 53135659, 53148485, 53163760, 53169259, 53177282, 53180497, 53191481, 53202453, 53205408, 53219102, 53234467, 53256052, 53261282, 53284175, 53304699, 53328991, 6869, 10955, 11937, 14695, 15646, 21860, 22711, 28789, 28958, 31602, 31721, 32562, 32613, 51709, 55324, 69746, 75770, 88769, 104500, 105011, 156334, 162380, 169770, 179816, 183636, 231138, 240572, 255287, 265693, 272820, 274220, 425401, 427921, 443319, 454409, 465627, 506272, 507998, 538754, 544692, 563327, 570144, 570793, 606776, 619063, 629047, 639109, 658407, 708294, 720336, 724924, 1035201, 1072286, 1155822, 1175481, 1194826, 1203587, 1208369, 1210172, 1482513, 1663546, 1713686, 1720903, 1779773, 1891798, 1894578, 1933490, 2042549, 2253719, 2401910, 2679720, 2698130, 2844458, 2857315, 2894228, 3015686, 3045169, 3054401, 3198728, 3433959, 3748416, 3851163, 3857297, 3931729, 3934812, 4102267, 4199865, 4210495, 4396468, 5030553, 5063550, 5157721, 5342013, 5346986, 5451374, 5517847, 5611108, 5938372, 6065661, 6304550, 6345703, 6387075, 6434138, 6440036, 6580537, 6779223, 6811536, 6863439, 7440318, 7543224, 8080682, 8456806, 8877260, 8984566, 9211925, 9343627, 9513191, 9736546, 9842563, 10102632, 10365303, 10378287, 10516939, 11911211, 12610501, 14346933, 14672793, 14728900, 14782774) group by rev_page) a WHERE num_editors>2 LIMIT 1000
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
.
Checking query status...