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.