Replicas browser and optimizer
ContentTranslation cleanup edits
This query is marked as a draft
This query has been published
Counts edits made by Framabot against CX errors on French Wikipedia. Shows results for each month
use frwiki_p; select year(rev_timestamp) as Year,MONTHNAME(rev_timestamp) as Month,count(rev_id) as Issues from revision_userindex INNER JOIN comment ON rev_comment_id = comment_id INNER JOIN page ON rev_page = page_id INNER JOIN actor ON rev_actor = actor_id where actor_user = 2523928 and page_namespace = 0 and comment_text like 'Bot: nettoyage traduction%' group by year(rev_timestamp),month(rev_timestamp) order by rev_timestamp desc limit 10000;
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