Fork of New article initiators and pages in year by Arjunaraoc
This query is marked as a draft This query has been published by Arjunaraoc.

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.

Checking query status...