Untitled query #83691

SQL

SELECT user_editcount, user_name, user_registration
FROM user

-- more than 8000 edits

-- not already an admin

-- not a bot
 -- MariaDB documentation says that LIKE is case insensitive, but my testing on Quarry reveals it to be case sensitive here
AND NOT EXISTS (SELECT * FROM user_groups WHERE ug_user = user_id AND ug_group = 'bot' )
AND LOWER(user_name) NOT LIKE '%bot'
AND LOWER(user_name) NOT LIKE '%bot %'

-- never blocked
-- need log_namespace = 2 for indexing reasons. log_namespace and log_title are indexed together. else the query times out.
AND NOT EXISTS (SELECT * FROM logging_logindex WHERE log_type = 'block' AND log_action = 'block' AND log_namespace = 2
                AND log_title = REPLACE(user_name, ' ', '_'))

-- account age 2+ years

-- edited in the last 30 days
-- checking >200 edits in last 30 days was too slow

-- RFA page does not exist yet (no previous RFAs)

-- advanced perms such as NPR, TE, etc??

ORDER BY user_editcount DESC
SQL

Checking query status...
