Replicas browser and optimizer
This query is marked as a draft
This query has been published
Count of edits that created a page in the mainspace by users who are currently in the bot usergroup and users who are not.
use mgwiktionary_p; select if(rev_actor in (select actor_id from actor join user_groups on ug_user = actor_user where ug_group = 'bot'), 'bot', 'not') as botness, count(*) as count from revision join page on page_id = rev_page where rev_parent_id = 0 and page_namespace = 0 group by botness;
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