SQL
x
USE wikidatawiki_p;
WITH page_creation_days AS
SELECT rev_page AS page_id, DATE_FORMAT(rev_timestamp, '%Y-%m-d%') AS date
WHERE rev_parent_id = 0;
SELECT COUNT(page_id) AS count, date
FROM page
JOIN page_creation_days USING (page_id)
WHERE page_namespace = 146
GROUP BY date
ORDER BY date;
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.