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'
   -- new page creations or moves
   AND (
     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(*) <= 12
SQL

Checking query status...
