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_namespace = 2 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