HujiBot Query Upgrades

SQL

use fawiki_p;
SELECT
  actor_name,
  GROUP_CONCAT(DISTINCT(ug_group) SEPARATOR '، ') AS groups,
  active_days
FROM
(
  SELECT
    actor_user,
    actor_name,
    COUNT(*) AS active_days
  FROM
  (
    SELECT DISTINCT
      actor_user,
      actor_name,
      LEFT(rev_timestamp, 8)
    FROM revision
    JOIN actor
      ON rev_actor = actor_id
    WHERE
      rev_timestamp > CONCAT(DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 YEAR), '%Y%m%d'), '000000')
  ) AS rev_days
  LEFT JOIN user_groups
    ON actor_user = ug_user
    AND ug_group = 'bot'
  WHERE
    ug_user IS NULL
    AND actor_user NOT IN (
      374638, /* پیام به کاربر جدید */
      285515 /* FawikiPatroller */
    )
  GROUP BY
    actor_user
  HAVING
    COUNT(*) > 100
) as users
LEFT JOIN user_groups
  ON actor_user = ug_user
  AND ug_group NOT IN (
    'uploader',
    'autopatrolled',
    'ipblock-exempt'
  )
GROUP BY
  actor_user
ORDER BY
  active_days DESC
SQL

Checking query status...
