Untitled query #78839

SQL

SELECT DISTINCT u.user_editcount, u.user_name, u.user_registration
FROM user u
INNER JOIN actor a ON u.user_id = a.actor_user
INNER JOIN page p ON p.page_namespace = 2 AND p.page_title = REPLACE(u.user_name, ' ', '_')
LEFT JOIN logging_logindex l ON l.log_namespace = 2 AND l.log_title = REPLACE(u.user_name, ' ', '_') AND l.log_type = 'block'
WHERE u.user_editcount > 10000
AND u.user_registration < DATE_SUB(NOW(), INTERVAL 2 YEAR)
AND l.log_id IS NULL
AND u.user_id NOT IN (SELECT ug.ug_user FROM user_groups ug WHERE ug.ug_group IN ('sysop', 'bot'))
AND a.actor_id IN (SELECT rc.rc_actor FROM recentchanges_userindex rc)
AND REPLACE(u.user_name, ' ', '_') NOT IN (SELECT SUBSTRING(p2.page_title, 24) FROM page p2 WHERE p2.page_namespace = 4 AND p2.page_title LIKE 'Requests_for_adminship/%')
AND p.page_id IN (SELECT cl.cl_from FROM categorylinks cl WHERE cl.cl_to = 'Wikipedia_Good_Article_contributors')
ORDER BY u.user_editcount DESC
SQL

Checking query status...
