Revisions by month for editors who joined FA WP in 2015

Fork of Revisions by month for editors who joined FA WP in 2015 by Huji

This query is marked as a draft This query has been published by Yamaha5.

SQL

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

SQL

Checking query status...