Untitled query #70761

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

select t2.rev_actor, r1.rev_timestamp, t2.rev_page, r1.rev_id
from revision r1
join (select r.rev_page, r.rev_actor, count(*) No_edits
from revision r
join page p on r.rev_page = p.page_id
join (select distinct(rev_actor)
	  from revision
	  join actor on rev_actor = actor_id
	  where rev_page in (424775, 10332988, 7259439, 609947, 673067, 1760669, 289919, 5222282, 1686370, 2976535)
		  and rev_actor not in (14126709, 18056118, 216043524, 14796318, 16375738, 22460537, 20266988, 563809, 9511030, 24468, 12761752, 14499063, 39925, 4432706, 43381, 953633, 10689166, 20533100, 19847846, 1612810, 264188, 8387952, 2223198, 3509975, 177986, 847016, 8980440, 6214873, 22009527, 9665885, 13823744, 7733289, 2967075, 6874869, 11172234, 27056630, 5147276, 5520467, 2827, 5134194, 4307, 15444490, 17224635, 188803383, 10904585, 5431, 14938428, 29655010, 7027479, 10015622, 5869011, 2130000, 36175903, 27270702, 9585176, 218915983, 830427, 9773229, 7950974, 5666009, 37466, 3011506, 19860659, 7746879, 2620394, 12145837, 25152719, 3359439, 10660234, 2789804, 166912, 16847663, 37223, 16477131, 15188542, 166509, 9826484, 9594842, 4292958, 8911656, 119960, 37201, 6440673, 6451853, 9171913, 17621853, 17616251, 284, 249704, 16733635, 21689777, 376333, 215737986, 16288579, 204103446, 11004708, 9220540, 35384, 4379715, 603698, 12172911, 4093490, 1586414, 5499193, 5578475, 5636984, 5731502, 193904013, 29384733, 1270151, 15214308, 10962635, 18116187, 5961506, 19244651, 184, 24577, 11506, 12510958, 216153498, 9871133, 194849034, 9278, 15811, 21572516, 29376529, 10852398, 4942192, 8731056, 16961639, 6115046, 2815241, 191152745, 6266430, 88691, 23935497, 205795513, 5568797, 3928337, 13964144, 5946, 19390776, 517706, 9017380, 14287535, 3518605, 18475305, 119243, 8271969, 3237983, 218442445, 20425276, 10813129, 5744357, 20974684, 16995931, 29867973, 21008486, 21668753, 9357494, 14344300, 16693307, 5774834, 7151258, 210, 16456511, 10599, 9976641, 218387192, 1830347, 962, 11484997, 5058835, 210976, 11832, 709767, 113408, 7938639, 1538185, 705550, 42558, 35887223, 2657139, 30774129, 13204716, 13204854, 35908721, 7516966, 6612980, 218124230, 8397470, 17664497, 21421794, 24003993, 29477, 3200627, 14294243, 2403666, 21828975, 63158, 15836621, 32993, 1292041, 5731619, 10640373, 8132176, 326, 13306436, 3415071, 4287573, 449094, 316021, 672892, 6217027, 5325267, 33261201, 14700773, 14700848, 211640630, 9857388, 20686001, 17724714, 4144161, 3049357, 4188, 3229342, 28070633, 3449815, 7423249, 684647, 10942040, 16579841, 8836327, 15279564, 2473804, 1061888, 6244133, 6596180, 16122095, 10261863, 3753164, 2099487, 1801850, 2692, 33107153, 26918548, 3403616, 2980035, 5411293, 59654, 45280, 30618, 9493401, 7470706, 7248260, 210033075, 4928287, 12488344, 20223518, 12601988, 6369744, 14259505, 7450628, 17255683, 2012912, 4038452, 3472350, 43820, 220560128, 20023991, 9229503, 18810592, 31862637, 35624214, 172181, 809038, 2670665, 4925186, 189848970, 6236558, 1168777, 218611944, 197869704, 10396799, 218715955, 5619356, 10276665, 220695559, 7123050, 9924617, 9233180, 7474979, 2385458, 20972241, 13005945, 535218, 43012, 13514798, 10750530, 6306782, 28445807, 494734, 8663577, 18775375, 29583917, 166649, 205590251, 6707345, 214905430, 30456351, 10571255, 21625807, 376082, 30679493, 20689472, 10409937, 9302065, 25677421, 16916379, 3022906, 14509999, 15454895, 221845645, 31007956, 81625, 7827212, 36084, 6570216, 1116679, 15857481, 786935, 14870827, 6001908, 8207987, 6065469, 15877641, 197503590, 347191, 29323, 6806669, 188757, 6387896, 6520359, 6327364, 221544702, 172185, 11930568, 15484047, 16272485, 222431932, 307, 12937478, 815494, 720179, 10734324, 10734325, 455285, 199572, 2534695, 10498627, 7640953, 4291047, 6238141, 14182478, 22676623, 9896807, 11245850, 7937356, 208196048, 6767330, 4240, 6379313, 6318668, 162, 6460238, 8234046, 589, 6460245, 8234029, 8234032, 8234040, 8234053, 4253, 898427, 703833, 201193270, 6698907, 1669933, 12439518, 11612447, 17850345, 190946, 32430555, 76499, 7637690, 24555235, 753722, 213289597, 1100, 24972727, 42047, 17191016, 13794298, 219863304, 11432468, 76939, 185330, 7326950, 16722329, 18413176, 24294, 7427898, 6355311, 6468054, 34646, 14026455, 28323306, 2608226, 1787307, 13364672, 207757678, 3272013, 1717768, 20452811, 249649, 19269907, 13813907, 9505327, 15274495, 17345942, 1175, 24512, 17582888, 19466152, 2812742, 172182, 79718, 24550, 14297961, 12326347, 1899440, 204238, 320366, 6268931, 3218, 2697, 4955097, 172179, 222678128, 9477072, 1411, 29715002, 24447, 9360547, 13511504, 202312501, 31827944, 5601174, 3895585, 25747982, 33165661, 17739839, 5748518, 24119009, 36183764, 191293384, 192619287, 198980722, 20871016, 4056126, 207506760, 17380871, 4109425, 3008487, 130746, 10305432, 42420, 18507598, 412, 10537008, 112577, 20696784, 9550219, 214493275, 859071, 573994, 919724, 9629292, 219196739, 17766668, 101369, 22574632, 4406287, 6787970, 304, 24409131, 29810799, 198685798, 8350332, 81200, 221316426, 14168976, 20336426, 217999031, 191026924, 606195, 4653, 14892191, 4987585, 13536185, 2761985, 8026384, 4122214, 324525, 3349907, 494731, 5697806, 3161083, 4438881, 18100686, 9202410, 5746054, 8675851, 202991275, 8194986, 302387, 21422092, 218702535, 46755, 215157217, 3621476, 207383938, 31180493, 4040886, 10962242, 17036594, 10592009, 6900364, 15949729, 14697470, 8497458, 17144496, 152725, 3155104, 7032885, 864562, 38800, 239898, 17557771, 14205032, 35540, 9174, 10601022, 6703434, 9261169, 217218094, 5167575, 847015, 10619069, 33273339, 5691609, 5691616, 7166158, 7662294, 7625519, 5694695, 14655731, 6723493, 17479026, 2711, 28580326, 19248590, 5985435, 5628455, 1380248, 6072344, 17493145, 7228277, 42291, 949, 1097563, 33733984, 10666410, 27274598, 9196615, 8108648, 7948911, 289456, 7651024, 12874028, 3308277, 212873428, 27305723, 16058366, 28895181, 7466770, 224, 1008506, 27507689, 252720, 22638780, 9731501, 8778882, 6019, 17654002, 24568691, 10262040, 3933, 57010, 11642116, 55088, 18288, 371277, 566453, 5322520, 26756707, 2234401, 3066017, 3104336, 3104348, 6837316, 17373643, 17380528, 20024198, 21742786, 127644, 10910681, 212912163, 3296732, 27587768, 16272008, 23224464, 7165783, 3563779, 6356011, 13005419, 32861664, 8855024, 220728614, 24730, 3574818, 27174356, 6325412, 10370452, 282001, 10327628, 16693794, 13488522, 18527097, 3629215, 24523, 18919761, 615615, 16181898, 1023, 5034985, 17186271, 27811, 2152888, 2270293, 5060638, 6535438, 11293752, 11553433, 7086, 2861, 214147936, 8184919, 221290, 20259177, 13566105, 6256109, 8347172, 84844, 7691903, 19842995, 7159481, 9795093, 1142412, 6323208, 28133933, 602503, 14901522, 8269891, 24307, 14273463, 744513, 8335394, 17192284, 37492, 208321476, 188768848, 1946411, 6166040, 14881004, 29547867, 22003224, 30910340, 29885505, 13515435, 19117521, 266404, 189571857, 10256639, 218329940, 50253, 23983158, 446291, 519695, 956534, 205844311, 3935966, 27621654, 198338242, 10740067, 5329513, 5428328, 5308591, 9915602, 13888195, 59617, 24999087, 1131204, 8215682, 9203807, 373556, 5742959, 8824273, 12957391, 204385846, 13782304, 5750744, 3006730, 932178, 1400670, 9371950, 5765602, 32630, 11078685, 6272403, 219485292, 9139, 758685, 494758, 1287237, 4862130, 21354867, 2997528, 19302336, 14589362, 204317, 742642, 4350854, 7566026, 21168786, 21549010, 4642265, 4643514, 6316713, 508, 7521956, 7567967, 899632, 5561584, 5777495, 4641202, 6588088, 132116, 1131208, 18963256, 221681309, 3331779, 210090804, 13722863, 81843, 2332056, 7210053, 1315544, 14033, 18835089, 4746, 2227304, 22115, 314453, 220341, 16063333, 10354061, 14236656, 20196211, 5530026, 6796837, 550618, 9621189, 33101, 9552659, 9228496, 216160728, 2958, 219884, 224278, 18330378, 6147327, 26521639, 243322, 5523972, 13840028, 2292981, 21366634, 20153776, 7470210, 8034785, 9369644, 4106303, 602506, 9171172, 168084, 13806908, 115185, 17239158, 6922413, 6973485, 7881932, 10972407, 24501, 18256634, 12961447, 12299, 216884087, 13002706, 14767213, 13651744, 6064734, 33286045, 222691845, 11002629, 16110744, 5756514, 16359336, 10538336, 177, 6229407, 10568890, 210374129, 10657, 11166332, 8209126, 1223840, 7679372, 18572029, 9235779, 33428069, 494729, 190369816, 110379, 18357227, 66244, 10241741, 11378860, 6962008, 14478, 315460, 189698000, 83571, 7176247, 25193153, 6392977, 1184715, 10602197, 5384875, 444010, 9682062, 9367895, 30005215, 21471002, 1038931, 201700154, 1299210, 9560320, 126836, 9050402, 11463621, 4203484, 6218741, 1436564, 586621, 8867362, 25679090, 9783264, 24707282, 4594819, 2687544, 4180543, 117707, 567242, 18616176, 17770, 30117061, 30683030, 494690, 202245496, 43818, 929652, 24166499, 19315213, 7286999, 5952831, 7392773, 8900159, 7729422, 83565, 6920287, 4166810, 1317081, 212100309, 163334, 6893314, 214234878, 131683, 30207385, 29758297, 35419733, 1824146, 606174, 7547069, 15873595, 249758, 3443051, 80595, 15107703, 4311, 6646162, 85619, 5919703, 1289767, 5020107, 13848276, 27040475, 1708324, 35186340, 5508263, 17566617, 5991580, 8044991, 42532, 586016, 34036611, 217866986, 3269771, 8276957, 12725242, 15852872, 659323, 16911539, 1630936, 5835315, 1667199, 25747365, 14204562, 1038, 18325270, 1124076, 15426, 5301148, 11456374, 16510297, 11647499, 43825, 3133150, 1424538, 7533774, 4311494, 3630179, 35583396, 9836127, 2144306, 9408929, 10182567, 267096, 29007794, 5991814, 6207691, 17068934, 37957, 6387898, 7966599, 752677, 5795423, 5545826, 1020, 100105, 10158413, 215059092, 8003143, 4270, 296366, 507305, 17774181, 4081504, 14965452, 42363, 32, 12912659, 13729270, 38356, 426221, 7930328, 7360053, 2034966, 253542, 16106553, 6194381, 11454823, 3304830, 28397081, 953655, 37571, 10688316, 31043499, 9529993, 33094, 30991924, 1870, 24735, 29767973, 30991892, 373712, 1568002, 11501023, 242495, 8933542, 482963, 42242, 7083726, 31378305, 26125052, 9885884, 1284801, 639860, 10808209, 24875440, 212864824, 118384, 1356092, 10563704, 200630101, 10894, 25298774, 73131, 5061277, 5052802, 15152217, 9251921, 3019505, 31067747, 28548405, 18408143, 16870995, 11008969, 11685950, 8400964, 6930894, 5118867, 5793587, 42476, 11860, 17397485, 10123046, 243155, 18151964, 98840, 197067460, 14823631, 81518, 1837280, 1752831, 3560425, 215006043, 10228130, 16867417, 14658378, 1435414, 21331457, 166969, 15481896, 35277, 8677505, 3673184, 85933, 5298847, 7262386, 131700, 2755, 21521108, 1352450, 15823864, 15814087, 752675, 9328729, 3962781, 4649333, 5454880, 
                   	  22989716, 42048, 35169780, 16658192, 5991998, 68199, 14994107, 4944547, 19171249, 198729139, 33589569, 249413, 2637155, 215378, 17071588, 16078, 578348, 129610, 329412, 8878525, 241230, 9923717, 13885391, 21363512, 10930277, 19187567, 17537370, 17588050, 43816, 8113311, 1510968, 2882536, 12238038, 5276, 72871, 4062358, 12194622, 26089, 8269331, 8665872, 8699353, 14166359, 16941364, 31611455, 2385923, 333758, 404756, 4933716, 9766753, 786934, 3825444, 17530893, 16780959, 22686293, 31969890, 30088113, 11112930, 159274, 7321960, 9296, 519171, 7042848, 13997288, 14540865, 14797100, 593982, 193677792, 8108431, 9204, 189355549, 2199738, 11518, 24124162, 550322, 213, 6059, 19670271, 550617, 215090560, 1567368, 5830171, 8462191, 10180509, 8864577, 4970662, 221196251, 8661401, 2413433, 33569975, 7306136, 901409, 18748379, 19749277, 342366, 8584496, 30541295, 8157915, 4435846, 9109, 21105266, 15789389, 1439913, 6756854, 13948876, 368146, 401934, 7825405, 8193374, 1627047, 880006, 46657, 4491184, 8883395, 239945, 9799141, 10448012, 1397653, 399990, 16435440, 1252423, 5035689, 9278696, 7796210, 446293, 10994110, 34895011, 31283811, 4431341, 214676385, 5985275, 46748, 1082434, 5662955, 16143554, 28792266, 5195073, 29612637, 24549, 6742708, 18668806, 244468, 4933419, 18259436, 22133, 11510562, 204857755, 2907429, 33807458, 504603, 13853364, 536, 6673313, 9706247, 35206, 11837047, 10882297, 188419916, 5904447, 218574561, 17572326, 14409826, 17269012, 12427941, 852699, 341224, 17294302, 23865307, 7866708, 7866714, 7207628, 6458442, 8393618, 8279706, 8389491, 7045107, 10975863, 10895206, 2213843, 20180522, 9817391, 4403973, 18147730, 341602, 214688898, 195069319, 18069, 3940571, 507997, 2281314, 14107764, 42367, 19044663, 3247268, 32946866, 358454, 302346, 4503294, 15562502, 1572037, 324517, 5915929, 13697734, 9739413, 7211963, 147692, 14076609, 11492461, 34510817, 34541894, 13140936, 4395168, 8580710, 1153478, 4234, 64088, 8848456, 264393, 8505423, 2269540, 8736266, 213137314, 13792097, 6700733, 4165473, 3994669, 16355116, 470418, 5508802, 24483, 21221647, 11733203, 24169413, 3283697, 2291239, 198693102, 7741510, 23127777, 388426, 33399004, 8775598, 7342446, 13140300, 4639358, 13321742, 874, 206515975, 182, 10476662, 30020546, 18719861, 15512509, 3350229, 7439931, 28563169, 8696194, 25834621, 4327834, 715819, 38233, 16371767, 14028514, 7485100, 6525732, 672811, 15697103, 5442642, 4518040, 6779390, 6788853, 216510157, 165644, 14121282, 33921845, 2431288, 6981903, 5394712, 31154412, 18863886, 35658185, 35407488, 216586954, 5697448, 6790307, 2382664, 5685304, 4879481, 1427239, 7911057, 181155, 9971639, 7353743, 21647441, 183, 12338680, 15174249, 20891948, 5488586, 214723533, 26935980, 22040578, 2556269, 31065859, 1207463, 10952555, 25872881, 13717354, 9143, 18828821, 4405039, 14955488, 3505103, 580236, 4176811, 131682, 511822, 42533, 1917001, 3634482, 8706999, 21271767, 1153479, 10347024, 8564931, 29751764, 12485109, 4780, 36299569, 3532, 9241370, 8650192, 9768643, 3372951, 205721047, 15280034, 6733, 129954, 16330541, 267097, 16598493, 11817, 217133032, 4516673, 121290, 214550, 10115273, 5762540, 24044143, 2014333, 3853911, 2750387, 204083, 9163, 1684378, 11847655, 10546471, 1470488, 2798102, 23853134, 251053, 21217181, 9627511, 16355749, 34543685, 8646, 5966525, 1725904, 9017428, 2702050, 18730722, 215132523, 22946518, 1743156, 11858, 8856491, 265, 219731603, 194675876, 8583855, 7955816, 18172674, 18451569, 16141135, 19532580, 15475121, 15507640, 17655039, 628372, 12235945, 202196804, 204085, 215522889, 11890779, 11885661, 11733371, 9633866, 14912137, 735296, 8112032, 21529231, 928570, 13284900, 994, 36375607, 8012946, 28267894, 200017643, 198977042, 129952, 3993072, 110747, 4720508, 491708, 11007235, 8777059, 10724481, 31803975, 216054613, 30465760, 13441098, 21093, 28687787, 13842325, 703858, 926464, 19627559, 8834736, 1399415, 59619, 17963138, 980237, 4066704, 311504, 725914, 239952, 8301889, 2757137, 21056639, 14044489, 20263402, 29651, 6080906, 4545790, 215027931, 16598909, 1540840, 84860, 6114225, 6896648, 4579203, 3745948, 198102944, 1269178, 2483412, 17354425, 3475533, 2826744, 13213822, 31797567, 4294000, 5053263, 8569280, 4305821, 14020353, 12428750, 16840207, 27598995, 8709725, 347745, 221582842, 320597, 6004825, 2275321, 210705909, 15526825, 26727556, 398853, 34220554, 13546549, 45319, 7180015, 13660308, 987729, 17947405, 453356, 540, 10231828, 37842, 3675873, 29310881, 7119874, 202258632, 7131573, 2214707, 2523303, 4219, 3909433, 14824375, 7974316, 5836773, 17140364, 26822094, 15798299, 59695, 571088, 15188449, 12221539, 2316934, 18296316, 25633212, 12723055, 7533009, 3142101, 20358959, 23852101, 257444, 1061879, 786930, 7744569, 8365076, 85618, 8243961, 8359833, 8365063, 8390024, 4387650, 37633, 7909448, 9810437, 13360967, 5891953, 11079899, 1520724, 5098844, 5754930, 1048985, 8056538, 24344079, 3981867, 51202, 31777834, 19279074, 17342191, 222061370, 14688680, 80738, 24550861, 24528366, 5434495, 3309052, 218071378, 6195888, 18503223, 17540, 1792050, 190987528, 24775, 6511547, 18790360, 7574894, 22336218, 23019712, 4051062, 18435928, 5735190, 1563698, 1901, 1561030, 4951286, 19273743, 13459265, 1847952, 27674770, 13092191, 8916990, 8813, 11833605, 3177425, 8463714, 7184283, 8882973, 4854628, 971918, 8975099, 2932993, 18160338, 5844376, 45205, 13651718, 4292199, 215758109, 17595585, 279697, 5782132, 16238410, 340687, 42284, 204259, 4127276, 7643134, 3783877, 19039710, 191535516, 2384668, 241091, 14140864, 16673794, 8286955, 28257375, 2907542, 296365, 3597711, 951144, 6262834, 951145, 14917722, 14917721, 14917731, 14917728, 22980089, 21196090, 9412924, 21243923, 1103607, 12511929, 6826337, 215720364, 17402866, 215903837, 8734639, 213672035, 35032700, 42531, 26151514, 43687, 19475614, 11774212, 30803366, 6113910, 217558666, 3782778, 326992, 25606551, 12084, 121257, 20416, 20223236, 20147168, 163325, 9012405, 15002081, 18613672, 32168707, 51040, 9286526, 9725236, 12216512, 11480948, 5278539, 424211, 25155305, 18563975, 443769, 5475571, 31458570, 221004279, 1312616, 3608904, 6981505, 13420494, 3672043, 18605725, 3981055, 14935106, 18081332, 8342416, 9848411, 4284277, 9499475, 3047020, 17947398, 30841600, 205625059, 1801467, 446292, 2769770, 5458023, 204142, 479085, 21792306, 20667971, 12591816, 5914797, 17327285, 16365175, 6435, 15475859, 1257187, 1934892, 215479969, 221027791, 11512173, 59647, 232714, 1566621, 945429, 10461042, 14829802, 14795034, 2533001, 34200713, 32276274, 13295074, 1398738, 86082, 8489757, 214952711, 5294892, 572633, 405703, 209789338, 203038527, 6362865, 2012625, 115174, 17936554, 28281553, 4873073, 12997811, 657585, 15920865, 1926954, 18814708, 8693630, 17006041, 6569693, 4327959, 2591335, 166078, 3708344, 42254, 602613, 6283983, 215247360, 9387220, 7240441, 15856108, 14543209, 5171487, 10819, 20775, 209965046, 253104, 20940556, 17698061, 10357743, 3858712, 15807886, 7746400, 4333284, 28644130, 659225, 2958001, 519818, 2358907, 6864262, 14093035, 6931350, 2355641, 28070665, 4270901, 204768253, 2968132, 8184671, 321476, 17501254, 11419282, 1179334, 6096538, 531028, 8416066, 26809683, 9703767, 16487447, 17196325, 839108, 29712676, 3771233, 867291, 1750706, 212268835, 172187, 7693, 8644328, 25213442, 14257666, 3879446, 320356, 13748688, 306931, 8449556, 40522, 1842172, 1457645, 6886208, 15637983, 715781, 6041, 20011727, 1911555, 31713096, 491871, 2423, 212403830, 703832, 20115307, 2999905, 4240115, 10663689, 188163, 42365, 2804569, 2035058, 5652695, 189561535, 27648266, 10632, 18862331, 7025605, 6262815, 2923913, 47505, 213778203, 19418967, 204177600, 18216878, 214817645, 7642605, 7583049, 10788197, 19357722, 82666, 4294, 15615897, 5252208, 16484040, 3646692, 214063017, 208154735, 20359425, 2791411, 204122, 16438305, 212252712, 449002, 19377631, 32354802, 211170477, 9432314, 204303, 202157781, 50406, 215571414, 2107155, 131692, 2320157, 204112, 9021067, 37836, 1095171)
      	  order by rev_actor) t1 on r.rev_actor = t1.rev_actor
where p.page_namespace = 0 and p.page_is_redirect = 0 and r.rev_minor_edit = 0
group by r.rev_page, r.rev_actor
having No_edits >= 5
      order by r.rev_page) t2 on t2.rev_actor = r1.rev_actor
where (t2.rev_page, t2.rev_actor) in (r1.rev_page, r1.rev_actor)
order by t2.rev_actor, r1.rev_timestamp
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...
