Untitled query #29060

SQL

WITH actor_uploaders_tocat AS (
SELECT actor_user
FROM revision
JOIN categorylinks  ON rev_page = cl_from
JOIN actor ON rev_actor = actor_id AND actor_user IS NOT NULL
WHERE rev_parent_id = 0
AND cl_to = "Images_from_Wiki_Loves_Monuments_2019"),

user_join AS (
SELECT actor_user, user_id, user_name, user_registration
FROM actor_uploaders_tocat
JOIN user
ON actor_user = user_id),

new_users AS (
SELECT DISTINCT user_name, user_registration, actor_user
FROM user_join
WHERE user_registration >= '20190901000000'
  AND user_registration <= '20190930235959')

SELECT COUNT(DISTINCT rev_id)
FROM revision
JOIN new_users ON rev_actor = actor_user
WHERE rev_timestamp >= '20191001000000'
  AND rev_timestamp <= '20191231235959'
  AND rev_parent_id = 0
SQL

Checking query status...
