HujiBot Query Upgrades

SQL

use fawiki_p;
SELECT DISTINCT
  rev_user_text,
  COUNT(*) cnt,
  CASE
    WHEN ufg_group IS NULL THEN ''
    ELSE '{{خیر|بله}}'
  END AS lostautopatrol
FROM revision
LEFT JOIN user_former_groups
  ON rev_user = ufg_user
  AND ufg_group IN ('autopatrolled', 'autopatrol')
LEFT JOIN page
  ON rev_page = page_id
WHERE
  rev_parent_id = 0
  AND page_is_redirect = 0
  AND page_namespace = 0
  AND rev_timestamp >
    CASE
      WHEN MONTH(CURDATE()) = 1 THEN CONCAT(
        YEAR(CURDATE()) - 1,
        '12',
        LPAD(DAY(CURDATE()), 2, 0),
        '000000'
      )
      ELSE CONCAT(
        YEAR(CURDATE()),
        LPAD(MONTH(CURDATE()) - 1, 2, 0),
        LPAD(DAY(CURDATE()), 2, 0),
        '000000'
      )
    END
  AND rev_user NOT IN (
    SELECT ug_user
    FROM user_groups
    WHERE ug_group IN ('autopatrolled', 'sysop', 'bot')
  )
  AND rev_user <> 0 /* anonymous users */
  AND rev_user <> 374638 /* پیام به کاربر جدید */
GROUP BY
  rev_user_text,
  ufg_group
HAVING cnt > 20
ORDER BY cnt DESC
SQL

Checking query status...
