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