Número de artigos criados por usuários novos

SQL

SELECT
 "MANTIDOS" ARTIGOS,
 SUM(TIMESTAMPDIFF(DAY, user_registration, rev_timestamp) < 1) REGISTRADO_ATÉ_24H,
 SUM(TIMESTAMPDIFF(DAY, user_registration, rev_timestamp) < 7) REGISTRADO_ATÉ_UMA_SEMANA,
 SUM(TIMESTAMPDIFF(DAY, user_registration, rev_timestamp) >= 7) REGISTRADO_MAIS_DE_UMA_SEMANA
FROM
 revision
 INNER JOIN page ON page_id = rev_page
 INNER JOIN actor ON actor_id = rev_actor AND actor_user IS NOT NULL
 INNER JOIN user ON user_id = actor_user
WHERE
 page_namespace = 0
 AND rev_timestamp > "20231116000000"
 AND rev_parent_id = 0
UNION
SELECT
 "ELIMINADOS",
 SUM(TIMESTAMPDIFF(DAY, user_registration, ar_timestamp) < 1),
 SUM(TIMESTAMPDIFF(DAY, user_registration, ar_timestamp) < 7),
 SUM(TIMESTAMPDIFF(DAY, user_registration, ar_timestamp) >= 7)
FROM
 archive
 INNER JOIN actor ON actor_id = ar_actor AND actor_user IS NOT NULL
 INNER JOIN user ON user_id = actor_user
WHERE
 ar_namespace = 0
 AND ar_timestamp LIKE "2023%"
 AND ar_parent_id = 0
SQL

Checking query status...
