SQL
x
use tewiki_p;
SELECT
substr(ar_timestamp,1,6),count(substr(ar_timestamp,1,8)) as count
-- count(substr(ar_timestamp,1,4)) as Main_space_deletions
FROM
archive,page
WHERE
-- archive.ar_parent_id = 0 AND
-- ar_namespace = 0
page_title=ar_title and
page_is_redirect=0 and
left(ar_timestamp,6) = 202012
GROUP BY substr(ar_timestamp,1,6)
-- order by substr(ar_timestamp,1,4)
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.