Replicas browser and optimizer
Revisions by month for editors who joined FA WP in 2015
This query is marked as a draft
This query has been published
use fawiki_p; select rev.rev_user, user_name, left(rev.rev_timestamp, 6) as yearmonth, count(rev.rev_id) as edits from revision rev join ( select user_id, user_name from ( select user_id, user_name, min(rev_timestamp) as first_edit from user join revision on rev_user = user_id group by user_id, user_name ) f left join user_groups on user_id = ug_user and ug_group = 'bot' where first_edit > '20150101000000' and first_edit < '20160101000000' and ug_group is null and user_id not in ( 514788, -- Fatranslator 489444 -- Maintenance script ) ) u2015 on rev.rev_user = u2015.user_id group by rev.rev_user, user_name, left(rev.rev_timestamp, 6) order by 1, 2
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