HujiBot Query Upgrades

SQL

use fawiki_p;
/*SELECT
  users.user_name,
  CONCAT(' ',REGEXP_REPLACE(GROUP_CONCAT(DISTINCT(ug_group) SEPARATOR '، '),'(uploader|autopatrolled|ipblock\-exempt)',''),' ') AS groups,
  active_days
FROM
(*/
  SELECT
    user_id,
    user_name,
    COUNT(*) AS active_days
  FROM
  (
    SELECT DISTINCT
      actor_user,
      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
    rev_user
  HAVING
    COUNT(*) > 100
/*) as users
JOIN user_groups
  ON user_id = ug_user
GROUP BY
  user_id
ORDER BY
  active_days DESC*/
SQL

Checking query status...
