use fawiki_p;

select rev_user, rev_user_text, mid(rev_timestamp, 9, 2) as hour, count(*) as edits

from revision

join

(

  select rev_user as user_id, count(rev_id)

  from revision

  left join user_groups

  on rev_user = ug_user

  and ug_group = 'Bot'

  where ug_group is null

  and rev_user <> 0

  group by rev_user

  having count(rev_id) > 3000

) freq

on rev_user = user_id

where rev_timestamp > '20150101000000'

group by rev_user, rev_user_text, mid(rev_timestamp, 9, 2)

order by 1, 2, 3, 4