SQL
x
use tewiki_p;
SELECT
substr(ar_timestamp,1,4),count(substr(ar_timestamp,1,4)) 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 and
page_title=ar_title
-- left(ar_timestamp,4) = 2020
GROUP BY substr(ar_timestamp,1,4)
-- 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.