Second Part - Quarry

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

use fawiki_p;
select
  user_id,
  user_name
from user
join actor
  on actor_user = user_id
join 
(
  select
    actor_user,
    count(*) cnt
  from revision_userindex
  join actor_revision
    on rev_actor = actor_id
  join page
    on page_id = rev_page
  where
    page_namespace = 0
    and rev_timestamp < '20201012000000' -- edits prior to nomination start date
  group by actor_user
  having count(*) >= 500
) fivehundred -- at least 500 edits in main namspace
  on user_id = fivehundred.actor_user
where
  user_id in ( -- list from https://quarry.wmflabs.org/query/48142
    173,
    892,
    1067,
    1385,
    1460,
    1509,
    2093,
    2274,
    5628,
    5654,
    5669,
    8483,
    8505,
    8629,
    8714,
    9395,
    9663,
    12622,
    12700,
    13410,
    16427,
    23528,
    29165,
    31275,
    47077,
    50177,
    57002,
    57277,
    64225,
    65570,
    66922,
    76905,
    81531,
    83507,
    89961,
    91486,
    91675,
    92110,
    96985,
    97798,
    99312,
    100371,
    103144,
    103284,
    105588,
    107215,
    107456,
    107851,
    110084,
    111931,
    113121,
    117089,
    118209,
    121295,
    121408,
    121756,
    122877,
    132869,
    132931,
    135252,
    136264,
    137113,
    137289,
    137940,
    137974,
    138640,
    138933,
    139561,
    140381,
    140486,
    146107,
    146647,
    150579,
    154219,
    154587,
    154867,
    154884,
    157018,
    158512,
    158832,
    161321,
    163197,
    164057,
    164716,
    165029,
    165177,
    166866,
    168172,
    169089,
    170809,
    171819,
    172616,
    172665,
    172740,
    173195,
    174481,
    174838,
    176460,
    176479,
    176686,
    179678,
    180655,
    180994,
    184036,
    186223,
    186422,
    193226,
    198962,
    201990,
    202152,
    203939,
    204084,
    206492,
    206958,
    212347,
    216468,
    223907,
    225657,
    225954,
    226115,
    226877,
    227421,
    229925,
    232365,
    232567,
    239125,
    239406,
    246863,
    248212,
    249403,
    250006,
    251265,
    256138,
    259488,
    260828,
    261260,
    262787,
    269242,
    269611,
    274146,
    274736,
    277028,
    282508,
    285515,
    292686,
    293107,
    294328,
    295175,
    296101,
    296196,
    298779,
    303438,
    305587,
    309070,
    310368,
    311021,
    313962,
    315405,
    316459,
    316582,
    317490,
    318046,
    319604,
    321044,
    324298,
    327206,
    330969,
    333265,
    338356,
    338538,
    347915,
    348960,
    349698,
    357399,
    358050,
    360550,
    363049,
    363222,
    364340,
    373298,
    381097,
    382514,
    384755,
    385690,
    385898,
    390342,
    390643,
    392180,
    396113,
    402108,
    403515,
    406290,
    412786,
    412914,
    417537,
    418299,
    418589,
    420041,
    420876,
    421830,
    422506,
    424222,
    424526,
    427312,
    429364,
    432898,
    434612,
    434738,
    436384,
    439097,
    448095,
    449853,
    450494,
    451039,
    460936,
    461228,
    464044,
    465373,
    468559,
    468678,
    471307,
    474412,
    475769,
    476003,
    479879,
    479977,
    480266,
    481835,
    483945,
    484433,
    485937,
    494340,
    499771,
    503060,
    505623,
    507441,
    510740,
    511272,
    512473,
    515075,
    515402,
    517183,
    520424,
    521776,
    523192,
    527404,
    529512,
    529912,
    530840,
    531583,
    534747,
    542664,
    545921,
    546384,
    548763,
    553346,
    559528,
    560527,
    561125,
    561396,
    561485,
    563608,
    566547,
    571402,
    572698,
    573979,
    579428,
    583555,
    585160,
    586129,
    589129,
    590442,
    591219,
    593066,
    595228,
    595408,
    595465,
    603693,
    604449,
    604492,
    607167,
    611479,
    612224,
    613775,
    614266,
    616716,
    617097,
    617929,
    620210,
    624321,
    625137,
    627088,
    628943,
    630305,
    631583,
    634051,
    637268,
    638270,
    643910,
    644434,
    645424,
    646701,
    646734,
    648245,
    649152,
    649601,
    651369,
    652219,
    653730,
    655029,
    657392,
    658442,
    658514,
    659479,
    660253,
    663169,
    664152,
    665103,
    667559,
    667843,
    669611,
    669700,
    669901,
    670962,
    672530,
    674253,
    674663,
    678333,
    678549,
    679401,
    683053,
    683428,
    684168,
    684855,
    687777,
    688086,
    688397,
    692057,
    692599,
    693241,
    693975,
    694697,
    695800,
    700530,
    704388,
    707243,
    707839,
    708991,
    710361,
    711538,
    712883,
    715097,
    715734,
    718052,
    718319,
    718321,
    719189,
    719350,
    719731,
    720702,
    722169,
    723145,
    724876,
    728539,
    728972,
    729234,
    730469,
    730474,
    730648,
    732162,
    733563,
    735614,
    737608,
    737734,
    738616,
    740119,
    740480,
    741765,
    742696,
    744495,
    746403,
    746705,
    747721,
    748706,
    748903,
    748908,
    749879,
    750682,
    751215,
    752062,
    753563,
    753722,
    754370,
    754852,
    756215,
    756437,
    757237,
    757361,
    757888,
    758386,
    759153,
    760280,
    760648,
    761054,
    761168,
    762412,
    764181,
    767994,
    769808,
    770824,
    773043,
    773862,
    774219,
    775220,
    781069,
    781544,
    785859,
    786004,
    786403,
    786527,
    788220,
    789541,
    790276,
    793480,
    795082,
    800461,
    800682,
    801962,
    802527,
    805236,
    807224,
    807245,
    809843,
    810671,
    813200,
    815609,
    817279,
    817315,
    817612,
    817902,
    818336,
    819887,
    821902,
    822294,
    822358,
    822650,
    824003,
    824848,
    825394,
    825520,
    826771,
    827674,
    828671,
    829016,
    831276,
    832232,
    832996,
    834242,
    834815,
    834836,
    835086,
    835649,
    838248,
    839284,
    839936,
    840882,
    841813,
    842232,
    842531,
    843015,
    843544,
    845399,
    845408,
    845618,
    846057,
    846154,
    846202,
    846862,
    847106,
    847476,
    847628,
    848821,
    850869,
    851955,
    852236,
    852399,
    852556,
    852672,
    854355,
    854691,
    855867,
    856104,
    856289,
    856378,
    856551,
    856621,
    857446,
    857529,
    857978,
    858303,
    858503,
    858739,
    859060,
    859219,
    859384,
    859592,
    859758,
    860466,
    860710,
    861753,
    862559,
    863054,
    863100,
    863349,
    863482,
    863703,
    863748,
    864206,
    864485,
    866171,
    866482,
    866655,
    866702,
    868148,
    868320,
    869202,
    869303,
    869390,
    870394,
    870436,
    870611,
    871310,
    871892,
    872415,
    872700,
    872830,
    873407,
    873903,
    874073,
    875005,
    876243,
    876299,
    876615,
    876741,
    877551,
    878250,
    878577,
    879122,
    879176,
    879305,
    879893,
    879934,
    880240,
    880732,
    881201,
    881720,
    882417,
    883326,
    883371,
    883579,
    884506,
    885327,
    885759,
    886122,
    886408,
    886535,
    886546,
    887385,
    887527,
    887907,
    889108,
    889345,
    889506,
    889818,
    890419,
    891620,
    892361,
    892828,
    893075,
    893530,
    893569,
    893632,
    893708,
    893889,
    893939,
    894005,
    894261,
    894933,
    895466,
    895742,
    896457,
    896483,
    896734,
    897674,
    897794,
    897900,
    898130,
    898903,
    899403,
    899562,
    899704,
    900019,
    900622,
    900922,
    901161,
    901851,
    901940,
    901964,
    902126,
    902305,
    902595,
    902606,
    903575,
    903758,
    904476,
    904664,
    905950,
    906159,
    906267,
    906326,
    906785,
    906862,
    906958,
    907180,
    907220,
    907604,
    907638,
    908233,
    908882,
    909596,
    909813,
    910031,
    910534,
    910696,
    910873,
    910916,
    911736,
    911961,
    912440,
    912496,
    912718,
    912903,
    913050,
    913215,
    913304,
    913514,
    914531,
    915551,
    915630,
    915854,
    916311,
    916354,
    916855,
    916919,
    917278,
    918582,
    918853,
    919472,
    919945,
    919970,
    920175,
    921284,
    921755,
    923306,
    923922,
    923943,
    924576,
    924619,
    925364,
    925517,
    925887,
    925989,
    926205,
    926302,
    926347,
    926587,
    926780,
    927048,
    927074,
    927260,
    927762,
    927860,
    927980,
    929638,
    930645,
    931207,
    931273,
    931274,
    931574,
    931658,
    931836,
    932172,
    932430,
    932502,
    932543,
    933660,
    934248,
    934420,
    934645,
    934763,
    935360,
    935823,
    935902,
    935963,
    936331,
    936846,
    937826,
    937959,
    938338,
    938488,
    939033,
    940228,
    940417,
    940622,
    941103,
    941641
  )
order by
  user_id,
  user_name
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...
