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
join revision_userindex on rev_actor = actor_id
JOIN page ON page_id = rev_page
WHERE user_editcount > 1000
--  AND user_registration < date_add(now(), interval -90 day) -- registered more than 3 months back
  AND rev_timestamp >= date_add(now(), interval -30 day)
  AND page_namespace = 0 -- Mainspace, from [[WP:Namespaces]]
  group by rev_actor
  having 'MainspaceEdits1m' >= 200 -- 300 mainspace edits in the last 30 days

SQL

Checking query status...