Untitled query #85109

SQL

/* checking the eligibilty of the list of voters 
*/

/* 2024年7月5日 (五) 通过的人事任免投票资格。
注册满120天，解任投票联署提出或上任投票开始120天前，编辑至少500次；并在联署提出或上任投票开始前90天内至少有1次编辑（不包括任何用户页及用户对话页）
OR
注册满120天, 编辑至少3000次
OR
注册满120天, 编辑条目至少1500次
*/


SELECT  user_id, user_name, user_registration, user_editcount           
FROM user
where user_name IN (
    "*angys*", "096型核潛艇", "0x0a", "0xDeadbeef", "103ful6", "111gangtie", "1233", 
    "13568zhu", "19", "1979己未年", "1F616EMO", "2015leon", "20204622hkus", 
    "2021 LEE KAR KEE JACKY", "215XBus", "263B", "28A02", "28daniel", "2thuriel", 
    "30000lightyears", "31cc", "339847214sd", "384", "3singooo", "50829!", "582ythp73", 
    "59cond12", "5k8421", "663highland", "85avenue", "89R", "919sth.", "94rain", 
    "A Chinese ID", "A small vibrissa", "A.J.K1911", "A0091206", "A01733824", "A02", 
    "A089049p", "A1472583698025", "A1688581", "A1Cafel", "A2093064-bot", "A2093064-bot2", 
    "A22234798", "A2569875", "A2569875-bot", "A2569875-maintenance", "A2569875-sandbox", 
    "A410945", "A5215Alan", "A52ljgh89", "A635683851", "A900788", "ACE5000", 
    "AHuRh", "AIeydwerai", "AKS471883", "ANG99", "AOrdinaryEditor", "ASDDASDE123", 
    "ASid", "AT", "ATannedBurger", "AVP 520", "AYAN1994", "Aaa839", "Aaa8841", 
    "Aaron8080174", "Aaroncheung 895", "Abby3780", "Abc root", "Abcet10", "Abihong", 
    "About123", "Acer2046", "Achanhk", "Achmad Rachmani", "Adafave2252", "Adam Azrael", 
    "Adam1206", "Adece033090", "Adeeliu1234", "AdrianLaw0330", "Adsa562", "AegonINVICTUS", 
    "Afgorjgvj", "Aflyhorse", "Ageoflo", "Agin1356", "Ailieeeee", "Amyvivianjane", 
    "An Macanese", "AnYiLin", "Andreitshua", "Andrew160299", "Andrew318", "Andy Calman", 
    "Andy woker er", "Andy199113", "AndyFung98", "AndyWu080500", "Andychan64", "Andythongchong"
);
SQL

Checking query status...
