This query is marked as a draft This query has been published by Danilo.mac.

SQL

AخA
 
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 LIKE "2023%"
 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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...