SQL
x
SELECT DATE_FORMAT(rev_timestamp, '%Y-%m') AS month, COUNT(page.*) AS count
FROM page
JOIN revision ON page.page_id = revision.rev_page
WHERE page_namespace = 0 AND rev_parent_id = 0 AND rev_timestamp BETWEEN 20200101000000 AND 20201231235959
GROUP BY month
ORDER BY month ASC;
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.