Week days (2) - Quarry

SQL

SET
  STATEMENT max_statement_time = 600 FOR
WITH rc_counts AS (
    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,
      SUM(
       	CASE
          WHEN rc_type = 0 THEN 1
          ELSE 0
        END
      ) AS total_edits
    FROM
      (
        SELECT
          rc_actor,
          rc_type,
          DAYOFWEEK(rc_timestamp) AS day
        FROM
          recentchanges_userindex AS recentchanges
        WHERE
          rc_ip IS NULL
          AND rc_bot = 0
          AND rc_type = 0 -- mw.edit (excludes mw.log, mw.categorize, etc)
      ) AS q
    GROUP BY
      rc_actor
  )
SELECT
  user_name,
  total,
  weekdays,
  dist_days
FROM
  rc_counts
  INNER JOIN actor_recentchanges AS actor ON rc_counts.rc_actor = actor.actor_id
  INNER JOIN user ON actor.actor_user = user.user_id
WHERE
  -- Contribs and distribution
  total_edits >= 40
  AND total = weekdays
  AND dist_days >= 5
  -- Further constraint to registered users
  AND actor_user IS NOT NULL
  -- Registration date
  AND user_registration IS NOT NULL
  AND user_registration >= "20200101000000" -- AND user_registration < "20200101000000"
  -- Filter out some unmarked bots
  AND user_name NOT LIKE '%Bot'
  -- Filter out past results
  -- AND user_name NOT IN  -- oh well, too big
  -- Filter out WikiEd and GLAM
  AND actor_id NOT IN (
    SELECT
      DISTINCT actor_id
    FROM
      change_tag
      INNER JOIN revision_userindex AS revision ON change_tag.ct_rev_id = revision.rev_id
      INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
    WHERE
      ct_tag_id = 530 -- WikiEdu: OAuth CID: 1232
      AND actor_user IS NOT NULL
    UNION ALL
    SELECT
      DISTINCT actor_id
    FROM
      recentchanges_userindex AS recentchanges
      INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
    WHERE
      rc_namespace = 4 -- Wikipedia:
      AND rc_title LIKE 'GLAM/%'
      AND rc_type = 0
      AND actor_user IS NOT NULL
  )
ORDER BY total DESC
SQL

Checking query status...
