NPP Recruitment - Editors by experience >4k mainspace edits

SQL

SELECT user_id, user_name, user_editcount, user_registration
FROM `user`
JOIN actor_user on actor_user=user_id
WHERE user_editcount > 4000
  AND user_registration < date_add(now(), interval -90 day) -- registered more than 3 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 user_name not in (select distinct actor_name
                          from revision
                          join page on rev_page=page_id
                          join actor on actor_id=rev_actor
                          where page_title="Requests_for_permissions/New_page_reviewer"
                          and page_namespace=4	-- "Wikipedia:" namespace
                          and rev_timestamp >= date_add(now(), interval -183 day)
                       ) -- leave out users who have edited Wikipedia:Requests_for_permissions/New_page_reviewer in the past 6 months
  AND (SELECT COUNT(*) FROM revision_userindex JOIN page ON page_id = rev_page
       WHERE rev_actor = actor_id
         AND rev_timestamp >= date_add(now(), interval -30 day)
         AND page_namespace = 0 -- Mainspace, from [[WP:Namespaces]]
       LIMIT 201) >= 200 -- 300 mainspace edits this month
SQL

Checking query status...
