NPP Recruitment - Editors by experience >10k edits (modified)

SQL

SELECT user_id, user_name, user_editcount, user_registration
FROM user
INNER JOIN actor_user on actor_user = user_id
WHERE user_editcount > 10000
  AND user_registration < date_add(now(), interval -180 day) -- registered more than 6 months back
  AND EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'extendedconfirmed')
  AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group in ( 'sysop', 'patroller', 'bot' ))
  AND NOT EXISTS (SELECT 1 FROM logging_logindex
                  WHERE user_name = log_title
                    AND log_namespace = 2
                    AND log_type = 'block' AND log_action = 'block') -- no blocks
  AND (SELECT COUNT(*) FROM logging_userindex
                  WHERE actor_id = log_actor
                    AND log_namespace = 0
                    AND log_type = 'create' AND log_action = 'create') > 25 -- 25 mainspace creations (articles or redirects)
  AND (SELECT COUNT(*) FROM (SELECT 1 FROM recentchanges_userindex
       WHERE rc_actor = actor_id
         AND rc_timestamp >= date_add(now(), interval -30 day)
         AND rc_namespace = 0 -- Mainspace, from [[WP:Namespaces]]
                             LIMIT 500) AS q) >= 500 -- 500 mainspace edits this month
AND EXISTS (SELECT 1 FROM recentchanges_userindex
       WHERE rc_actor = actor_id
         AND rc_namespace = 4
         AND rc_title LIKE 'Articles_for_deletion/%') -- AFD participation in 90 days
SQL

Checking query status...
