SQL
x
use tewiki_p;
SELECT
substr(ar_timestamp,1,8),count(substr(ar_timestamp,1,8)) as mainspace_deletions
FROM
archive
WHERE
archive.ar_parent_id = 0 AND
ar_namespace = 0 and
substr(ar_timestamp,1,4) ="2024"
GROUP BY substr(ar_timestamp,1,8)
order by substr(ar_timestamp,1,8)
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.