Fork of
NewPagesFeed pages tagged with anything
by Samwilson
This query is marked as a draft
This query has been published
by Samwilson.
SQL
x
USE commonswiki_p;
SELECT DATE(rev_timestamp), COUNT(*)
FROM change_tag_def
JOIN change_tag ON ( ctd_id = ct_tag_id )
JOIN revision ON ( ct_rev_id = rev_id )
WHERE ctd_name like '%343'
GROUP BY DATE(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.