Untitled query #77310

SQL

SELECT DISTINCT ar.actor_name AS ll_actor_name,
                GROUP_CONCAT(ug.ug_group) AS user_groups,
                MAX(rui.rev_timestamp) AS last_edit_date
FROM actor_revision ar
JOIN user_groups ug ON ar.actor_user = ug.ug_user
JOIN user u ON ar.actor_user = u.user_id
LEFT JOIN ipblocks ipb ON ar.actor_user = ipb.ipb_user
JOIN revision_userindex rui ON ar.actor_id = rui.rev_actor
WHERE ug.ug_group IN ('editor', 'autoreview', 'uploader')
  AND ipb.ipb_user IS NULL
  AND rui.rev_timestamp <= DATE_SUB(NOW(), INTERVAL 1 YEAR)
GROUP BY ar.actor_name;
SQL

Checking query status...
