Early gaming - experiment

SQL

SET
  STATEMENT max_statement_time = 60 FOR
SELECT
  actor_id,
  actor_name,
  edit_count,
  non_empty_count
FROM
  (
    SELECT
      actor_id,
      actor_name,
      COUNT(*) AS edit_count,
      SUM(
        LENGTH(
          TRIM(
            REGEXP_REPLACE(comment_text, '/\\* .* \\*/ *', '')
          )
        ) > 0
      ) AS non_empty_count
    FROM
      recentchanges_userindex AS recentchanges
      INNER JOIN comment_recentchanges AS comment ON recentchanges.rc_comment_id = comment.comment_id
      INNER JOIN actor_recentchanges AS actor ON recentchanges.rc_actor = actor.actor_id
      INNER JOIN user ON actor.actor_user = user.user_id
    WHERE
      TRUE
      AND rc_source IN ('mw.edit')
      AND rc_bot = 0
      AND actor_user IS NOT NULL
      AND user_registration >= "20220301000000"
      AND ipb_address IS NULL
    GROUP BY
      actor_id
    HAVING
      edit_count < 500
      AND edit_count > 30
      AND non_empty_count / edit_count >= 0.95
  ) AS main_q
  LEFT OUTER JOIN ipblocks ON actor_id = ipblocks.ipb_by_actor
WHERE
  TRUE
  AND ipblocks.ipb_by_actor IS NULL
SQL

Checking query status...
