autopatrolled with no edits in last 5 years by edit count

SQL

#SELECT actor_name, COUNT(rev_id) as edits# , DATE_FORMAT(rev_timestamp,'%Y-%m') as month
#FROM revision_userindex JOIN actor
#ON rev_actor = actor_id
#WHERE actor_name in  ('Vexations', 'Joe Roe')
#GROUP BY rev_actor
#ORDER BY edits ASC

SELECT user_name,  user_editcount 
FROM user
WHERE user_name IN (SELECT actor_name
FROM actor 
JOIN user_groups ON ug_user = 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)
))
ORDER BY user_editcount ASC
SQL

Checking query status...
