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
   AND rc_type = 1
   AND rc_namespace = 0
                         GROUP BY actor_id)
SELECT rev_actor, 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(*) < 20
SQL

Checking query status...
