Replicas browser and optimizer
Percent of bot edits in previous month (enwiki, articles only)
This query is marked as a draft
This query has been published
select rc_bot as is_bot, count(*) as edits, (COUNT(*) / (SELECT COUNT(*) FROM etwiki_p.recentchanges where rc_namespace = 0)) * 100 AS 'Percentage of all edits' FROM etwiki_p.recentchanges where rc_namespace = 0 group by 1;
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