Autopatrolled users who haven't edited in 5 years

Fork of autopatrolled users who haven't edited in 5 years by Vexations

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

SQL

SELECT actor_name
FROM actor 
JOIN user_groups ON ug_user = actor.actor_user 
JOIN user ON user_id = actor.actor_user
WHERE ug_group = 'autoreviewer'
AND actor_name NOT IN ( #users who created an article in the last month
  SELECT actor_name
  FROM revision_userindex
  JOIN page ON revision_userindex.rev_page = page.page_id
  JOIN actor ON revision_userindex.rev_actor = actor.actor_id
  JOIN user_groups ON ug_user = actor.actor_user 
  WHERE ug_group = 'autoreviewer'
  #AND rev_parent_id = 0
  #AND page_namespace = 0
  #AND page_is_redirect = 0
  AND rev_timestamp > (NOW() - INTERVAL 5 YEAR)
)
AND actor_user IS NOT NULL
ORDER BY user_editcount

SQL

Checking query status...