Untitled query #32692

SQL

use arwiki_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 IN (SELECT
                          user_name
                        FROM user
                        JOIN user_groups
                        ON ug_user = user_id
                        WHERE ug_group IN ("bot", "editor", "flow-bot", "ipblock-exempt", "autoreview", "uploader"))
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)
AND user_editcount = (SELECT
                       user_editcount
                     FROM user
                     WHERE user_name = user_id)                     
GROUP BY user_name
LIMIT 1000;
SQL

Checking query status...
