Replicas browser and optimizer
This query is marked as a draft
This query has been published
This re-uses code as in query https://quarry.wmflabs.org/query/52529 and further to discussion at https://www.mediawiki.org/wiki/Talk:XTools. For the given user account, this gives monthly totals (split out per namespace) for all edits.
SELECT YEAR(rev_timestamp) AS `year`, MONTH(rev_timestamp) AS `month`, page_namespace, COUNT(rev_id) AS `count` FROM revision_userindex JOIN page ON (rev_page = page_id) WHERE rev_actor = (SELECT actor_id FROM actor_revision WHERE actor_name = 'VahurzpuBot') GROUP BY YEAR(rev_timestamp), MONTH(rev_timestamp), page_namespace
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in