This query is marked as a draft This query has been published by Uhai.

SQL

AخA
 
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...