Untitled query #80620

SQL

SELECT us.user_registration, us.user_editcount, us.user_id, us.user_name from user us
join user_groups ug on ug.ug_user = us.user_id #and ug.ug_group = "sysop"
where us.user_editcount > 10000          #1a. At least 10,000 total edits
and us.user_registration <20210101000000 #3. Account registered at least three years ago
limit 1000;

#select user_name from user join user_groups on ug_user = user_id and ug_group = "sysop"
#where not exists (select * from page where page_namespace=4 and page_title=concat("Requests_for_adminship/",replace(user_name," ","_")))
#and not exists (select * from user_groups ug2 where ug2.ug_user = user_id and ug2.ug_group = "bot")
SQL

Checking query status...
