Autopatrolled users who haven't edited in 5 years

SQL

SELECT rev_actor, MAX(rev_timestamp) AS last_edit
FROM revision_userindex
WHERE rev_actor IN
(
	SELECT actor_id
	FROM user_groups
    JOIN actor ON actor_user = ug_user
	WHERE ug_group = 'autoreviewer'
)
GROUP BY rev_actor;

#SELECT user_name, user_editcount, MAX(rev_timestamp) AS last_edit, ug_group
#FROM page, revision, user, user_groups
#WHERE page_id = rev_page
#AND ug_user = user_id
#AND rev_user = user_id
#AND ug_group = 'autoreviewer'
#AND last_edit < (NOW() - INTERVAL 5 YEAR)
#GROUP BY user_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 have edited in the last five years
#  SELECT rev_actor
#  FROM revision
#  WHERE rev_timestamp > (NOW() - INTERVAL 5 YEAR)
#)
#AND actor_user IS NOT NULL
#ORDER BY user_editcount
SQL

Checking query status...
