SQL
x
USE arwiki_p;
SELECT COUNT(page_title)
FROM revision
INNER JOIN page ON rev_page = page_id
WHERE page_namespace = 0
AND rev_user_text = 'Elph'
AND rev_timestamp BETWEEN 20150101000000 AND 20161230000000
AND rev_parent_id = 0
AND page.page_is_redirect = 0;
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.