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 > 20211201000000
   -- new page creations
   AND rc_type = 1
   AND rc_namespace = 0
                         GROUP BY actor_id)
SELECT rc_actor, COUNT(*)
FROM recentchanges_userindex AS recentchanges
INNER JOIN first_creations ON recentchanges.rc_actor = first_creations.first_creation_actor
WHERE
TRUE
AND rc_type = 0
AND rc_timestamp < first_creation_timestamp
GROUP BY rc_actor
HAVING COUNT(*) < 20
SQL

Checking query status...
