Enwiki editors who might make good admins

SQL

SELECT user_editcount, user_id, user_name, user_registration
FROM user

-- more than 8000 edits
WHERE user_editcount > 8000

-- not an admin
AND (SELECT COUNT(*) FROM user_groups WHERE ug_user = user_id AND ug_group = 'sysop' ) = 0

-- not a bot
AND (SELECT COUNT(*) FROM user_groups WHERE ug_user = user_id AND ug_group = 'bot' ) = 0
AND user_name NOT LIKE '%Bot' -- LIKE is case insensitive in MariaDB
AND user_name NOT LIKE '%Bot %' -- LIKE is case insensitive in MariaDB

-- TODO: add RFA page does not exist (no previous RFAs)
-- TODO: add never blocked
-- TODO: account age 2+ years
-- TODO: advanced perms such as NPR, TE, etc.

ORDER BY user_editcount DESC
SQL

Checking query status...
