Week days - Quarry

SQL

SET
  STATEMENT max_statement_time = 300 FOR
SELECT
  user_name,
  total,
  weekdays,
  dist_days
FROM
  (
    SELECT
      rc_actor,
      COUNT(*) AS total,
      SUM(
        CASE
          WHEN day = 1 THEN 0
          WHEN day = 7 THEN 0
          ELSE 1
        END
      ) AS weekdays,
      COUNT(DISTINCT day) AS dist_days
    FROM
      (
        SELECT
          rc_actor,
          DAYOFWEEK(rc_timestamp) AS day
        FROM
          recentchanges
          INNER JOIN change_tag ON recentchanges.rc_id = change_tag.ct_rc_id
          INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
        WHERE
          rc_ip IS NULL
          AND rc_bot = 0
          AND change_tag_def.ctd_name = 'visualeditor'
      ) AS q
    GROUP BY
      rc_actor
  ) AS p
  INNER JOIN actor ON p.rc_actor = actor.actor_id
  INNER JOIN user ON actor.actor_user = user.user_id
WHERE
  total >= 20
  AND total = weekdays
  AND dist_days = 5
  AND user_registration IS NOT NULL
  AND user_registration >= "20200401000000" -- AND user_registration < "20210101000000"
  AND user_name NOT LIKE '%Bot'
  ORDER BY total DESC
SQL

Checking query status...
