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 LOWER(user_name) NOT LIKE '%bot' -- MariaDB says that LIKE is case insensitive, but my testing on Quarry reveals it to be case sensitive here
AND LOWER(user_name) NOT LIKE '%bot %'

-- 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...
