Untitled query #80620

SQL

SELECT * #us.user_registration, us.user_editcount, us.user_id, us.user_name 
from user us
#AND user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'sysop')
where us.user_id not in (select ug.ug_user from user_groups ug on ug.ug_group = "sysop")
and 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...
