NPP Recruitment - Editors by experience >10k edits

With a little help from [[User talk:Cryptic#A Little help with a query]] circa 7 Feb 2020.
Editors who are extended confirmed, are not new page patrollers or sysops, have not been blocked in the last year, have at least 10,000 edits in the last 3 months, 500 mainspace edits in the last month.

SQL

SELECT user_id, user_name, user_editcount, user_registration
FROM `user`
JOIN actor_user on actor_user=user_id
WHERE user_editcount > 10000
  AND user_registration < '20230328000000'
  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 = 'sysop') -- administrator
  AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'patroller') -- new page patroller
  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 revision_userindex JOIN page ON page_id = rev_page
       WHERE rev_actor = actor_id
         AND rev_timestamp >= '20230528000000'
         AND page_namespace = 0 -- Mainspace, from [[WP:Namespaces]]
       LIMIT 500) >= 500 -- 500 mainspace edits this month
  ;

SQL

Checking query status...