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 actor_name, user_editcount
  FROM user 
  JOIN actor ON actor_name = user_name
  JOIN user_groups ON ug_user = actor.actor_user 
  WHERE ug_group = 'autoreviewer'
  AND actor_name NOT IN ( 
    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)
  )
GROUP BY actor_name  
ORDER BY user_editcount ASC

SQL

Checking query status...