NPP Recruitment - Editors by experience >7k mainspace edits

Fork of NPP Recruitment - Editors by experience >8k edits by MPGuy2824

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

SQL

SELECT user_id, user_name, user_editcount, user_registration, count(*) as 'MainspaceEdits1m'
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 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

SQL

Checking query status...