Untitled query #50802

SQL

SELECT 
    u.user_name, 
    u.user_editcount, 
    u.user_registration, 
    rev.rev_timestamp AS 'Last edit', 
    GROUP_CONCAT(DISTINCT ug1.ug_group) AS 'user_groups'
FROM 
    `user` u
JOIN 
    actor a ON a.actor_user = u.user_id
JOIN 
    revision_userindex rev_ui ON rev_ui.actor_id = a.actor_id
JOIN 
    revision rev ON rev.rev_id = rev_ui.rev_id
LEFT JOIN 
    user_groups ug1 ON u.user_id = ug1.ug_user
WHERE 
    rev.rev_timestamp < DATE_FORMAT(NOW() - INTERVAL 1825 DAY, '%Y%m%d%H%i%S')
GROUP BY 
    u.user_id, u.user_name, u.user_editcount, u.user_registration, rev.rev_time
SQL

Checking query status...
