Autopatrolled users who haven't edited in 5 years

Fork of autopatrolled users who haven't edited in 5 years by Vexations

This query is marked as a draft This query has been published by Joe Roe.

SQL

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