Untitled query #23951

SQL

use arwiki_p;
SELECT DISTINCT
  usrtmp.user_name,
  usrtmp.user_editcount,
  usrtmp.rev_timestamp AS first_edit,
  rv1.rev_timestamp AS last_edit,
  usrtmp.groups
FROM revision AS rv1
JOIN (SELECT
        user_id,
        user_name,
        user_editcount,
        rev_timestamp,
        GROUP_CONCAT(ug_group) AS groups
      FROM user
      LEFT JOIN user_groups
      ON ug_user = user_id
      JOIN revision
      ON rev_user = user_id
      WHERE user_editcount > 2500
      AND user_id NOT IN (SELECT
                            ug_user
                          FROM user_groups
                          WHERE ug_group IN ("bot", "sysop", "reviewer"))
      AND rev_timestamp = (SELECT
                             MIN(rev_timestamp)
                           FROM revision
                           WHERE rev_user = user_id)
      AND rev_timestamp < DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 YEAR),'%Y%m%d%H%i%s')
      GROUP BY user_id) AS usrtmp
ON usrtmp.user_id = rv1.rev_user
WHERE rv1.rev_timestamp = (SELECT
                             MAX(rev_timestamp)
                           FROM revision
                           WHERE rev_user = usrtmp.user_id)
AND rv1.rev_timestamp > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 MONTH),'%Y%m%d%H%i%s')
ORDER BY usrtmp.user_name ASC;
SQL

Checking query status...
