Untitled query #32701

SQL

use arwiki_p;
SELECT DISTINCT
  rev_user_text,
  GROUP_CONCAT(ug_group)
FROM revision_userindex
JOIN user
ON user_name = rev_user_text
JOIN user_groups
ON ug_user = user_id
WHERE user_name IN (SELECT DISTINCT user_name FROM user JOIN user_groups ON ug_user = user_id WHERE ug_group IN ("autoreview"))
AND (SELECT
       MAX(rev_timestamp)
     FROM revision
     WHERE rev_user = user_id) < DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 6 MONTH),'%Y%m%d%H%i%s')
AND rev_timestamp = (SELECT
                       MAX(rev_timestamp)
                     FROM revision
                     WHERE rev_user = user_id)
GROUP BY user_name
LIMIT 10;
SQL

Checking query status...
