AC gaming - Quarry

SQL

WITH first_creations AS (
  SELECT
    actor_id AS first_creation_actor,
    MIN(rc_timestamp) AS first_creation_timestamp
  FROM
    actor_recentchanges AS actor
    INNER JOIN user ON actor.actor_user = user.user_id
    INNER JOIN recentchanges_userindex AS recentchanges ON recentchanges.rc_actor = actor.actor_id
  WHERE
    TRUE
    AND user_registration > '20211101000000'
    AND (
      -- new page creations or moves
      rc_source = 'mw.new'
      OR (
        rc_source = 'mw.log'
        AND rc_log_type = 'move'
      )
    )
    AND rc_namespace = 0
  GROUP BY
    actor_id
)
SELECT
  actor_name,
  COUNT(*)
FROM
  revision_userindex AS revision
  INNER JOIN first_creations ON revision.rev_actor = first_creations.first_creation_actor
  INNER JOIN actor_recentchanges AS actor ON revision.rev_actor = actor.actor_id
WHERE
  TRUE
  AND rev_timestamp > '20211101000000'
  AND rev_timestamp < first_creation_timestamp
GROUP BY
  rev_actor
HAVING
  COUNT(*) <= 13
SQL

Checking query status...
