Untitled query #3975

SQL

USE simplewiki_p;
SELECT DISTINCT user_name, rev_timestamp, GROUP_CONCAT(ug_group) FROM user JOIN user_groups ON ug_user = user_id JOIN revision ON rev_user = user_id WHERE user_name NOT IN (SELECT user_name FROM user JOIN user_groups ON ug_user = user_id WHERE ug_group IN ('rollbacker')) AND (SELECT MAX(rev_timestamp) FROM revision WHERE rev_user = user_id) < DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 YEAR),'%Y%m%d%H%i%s') AND rev_timestamp = (SELECT MAX(rev_timestamp) FROM revision WHERE rev_user = user_id) GROUP BY user_name;
SQL

Checking query status...
