Draft gaming - Quarry

SQL

SET
  STATEMENT max_statement_time = 120 FOR
SELECT DISTINCT
  main_q.actor_id,
  main_q.actor_name,
  recentchanges.rc_title
FROM
  (
    SELECT
      actor_id,
      actor_name,
      COUNT(*) AS edit_count,
      SUM(
        LENGTH(
          TRIM(
            REGEXP_REPLACE(comment_text, '/\\* .* \\*/ *', '')
          )
        ) > 0
      ) AS non_empty_count,
      SUM(rc_title LIKE 'GLAM/%') is_glam,
      SUM(comment_text LIKE '%The Wikipedia Adventure%') AS is_twa,
      SUM(comment_text LIKE '%#1lib1ref%') AS is_event,
      SUM(DAYOFWEEK(rc_timestamp) IN (2, 3, 4, 5, 6)) AS weekday_edit_count,
      SUM(rc_namespace = 118) AS draft_edit_count,
      COUNT(DISTINCT DAYOFYEAR(rc_timestamp)) AS distinct_days
    FROM
      recentchanges_userindex AS recentchanges
      INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
      INNER JOIN user ON actor.actor_user = user.user_id
      INNER JOIN comment_recentchanges AS comment ON recentchanges.rc_comment_id = comment.comment_id
    WHERE
      TRUE
      AND rc_source IN ('mw.edit', 'mw.new')
      AND rc_bot = 0
      AND actor_user IS NOT NULL
      AND user_registration >= "20220301000000"
      AND user_editcount < 50
    GROUP BY
      actor_id
    HAVING
      edit_count < 50
      AND edit_count > 10
      AND draft_edit_count / edit_count >= 0.5
      AND weekday_edit_count / edit_count >= 0.8
      AND distinct_days >= 1
      AND is_twa / edit_count < 0.01
      AND is_event = 0
      AND is_glam = 0
  ) AS main_q
  INNER JOIN recentchanges_userindex AS recentchanges ON main_q.actor_id = recentchanges.rc_actor
WHERE
  TRUE
  AND rc_source IN ('mw.new')
  AND rc_namespace = 118
ORDER BY main_q.actor_name ASC, rc_title ASC
SQL

Checking query status...
