HujiBot Query Upgrades

SQL

use fawiki_p;
/*SELECT
  rev_user_text,
  STR_TO_DATE(LEFT(min(rev_timestamp), 8), '%Y%m%d') AS sunrise,
  STR_TO_DATE(LEFT(min(sunset), 8), '%Y%m%d') AS sunset,
  old_edits,
  COUNT(rev_id) AS recent_edits,
  GROUP_CONCAT(DISTINCT(ug_group) SEPARATOR ' ') AS groups,
  CASE
    WHEN ipb_user IS NULL THEN ''
    ELSE '{{بله}}'
  END AS blocked
FROM revision
JOIN actor
  ON rev_actor = actor_id
JOIN user
  ON actor_user = user_id
JOIN (*/
  SELECT
    user_id old_user,
    max(rev_timestamp) sunset,
    COUNT(rev_id) AS old_edits
  FROM revision
  JOIN actor
    ON rev_actor = actor_id
  JOIN user
    ON actor_user = user_id
  WHERE
    user_id <> 0
    AND rev_timestamp < CONCAT(
      YEAR(CURDATE()) - 3,
      LPAD(MONTH(CURDATE()) , 2, 0),
      '01000000'
    )
  GROUP BY user_id
/*) old
  ON old_user = user_id
LEFT JOIN user_groups
  ON user_id = ug_user
LEFT JOIN ipblocks
  ON ipb_user = rev_user
WHERE
  rev_user <> 0
  AND rev_timestamp > CONCAT(
    YEAR(CURDATE()),
    LPAD(MONTH(CURDATE()) , 2, 0),
    '01000000'
  )
  AND rev_user NOT IN (
    SELECT rev_user
    FROM revision
    WHERE
      rev_user <> 0
      AND rev_timestamp < CONCAT(
        YEAR(CURDATE()),
        LPAD(MONTH(CURDATE()) , 2, 0),
        '01000000')
      AND rev_timestamp > CONCAT(
        YEAR(CURDATE()) - 3,
        LPAD(MONTH(CURDATE()) , 2, 0),
        '01000000'
      )
)
GROUP BY rev_user_text*/
SQL

Checking query status...
