Revisions by month for editors who joined FA WP in 2015

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...