Enwiki editors who might make good admins 2

SQL

SELECT user_editcount, user_id, user_name, user_registration
FROM user
LEFT JOIN logging_logindex ON log_type = 'block' AND log_action = 'block' AND log_title = REPLACE(user_name, ' ', '_')

-- more than 8000 edits
WHERE user_editcount > 8000

-- not already 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 documentation 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 %'

-- never blocked
AND log_title IS NULL

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

ORDER BY user_editcount DESC
SQL

Checking query status...
