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 actor
    JOIN revision_userindex ON revision_userindex.rev_actor = actor.actor_id
    JOIN user_groups ON ug_user = actor.actor_user 
    WHERE ug_group = 'autoreviewer'
    AND rev_timestamp > (NOW() - INTERVAL 5 YEAR)
  )
)
ORDER BY user_editcount ASC
SQL

Checking query status...
