SQL
AخA
SELECT
LEFT(rev_timestamp,4) AS iyear,
COUNT(*) as num_articles
FROM revision
LEFT JOIN page
ON page_id = rev_page
where rev_actor != 0 AND page_namespace=0 AND rev_parent_id = 0
GROUP BY LEFT(rev_timestamp,4)
ORDER BY iyear DESC
LIMIT 10000;
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.