SQL
x
USE skwiki_p;
SELECT
YEAR(rf.rev_timestamp), COUNT(*)
FROM
page p, revision rf
WHERE
rf.rev_page = p.page_id and rf.rev_parent_id = 0 and
p.page_namespace = 0 and
p.page_is_redirect = 0 and
rf.rev_user_text = 'Wizzo-Bot'
GROUP BY
YEAR(rf.rev_timestamp)
ORDER BY
YEAR(rf.rev_timestamp)
;
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.