autopatrolled users who haven't edited in 5 years

SQL

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)
)

SQL

Checking query status...