gistfile1.txt

create table awight_meta_edit_counts
  select
    u.username,
    left(r.rev_timestamp, 6),
    count(*)
  from metawiki.revision r
  join awight_meta_wmf_accounts u
    on r.rev_user_text=u.username
  group by 1,2;