Untitled query #24358

SQL

use jawiki_p;
select
  month,
  sum( case is_registered when 0 then edit_count else 0 end ) as edit_count_by_anonymous,
  sum( case when (is_registered = 1 and is_bot = 0) then edit_count else 0 end ) as edit_count_by_registered,
  sum( case is_bot when 1 then edit_count else 0 end ) as edit_count_by_bot
from (
  select
    left(rev_timestamp, 6) as month,
    if(rev_user = 0, 0, 1) as is_registered,
    if(ufg_group = "bot" or ug_group ="bot", 1,0) as is_bot,
    count(*) as edit_count
  from revision_userindex
  left outer join user_former_groups on rev_user = ufg_user and ufg_group = "bot"
  left outer join user_groups on rev_user = ug_user and ug_group = "bot"
  group by left(rev_timestamp, 6), if(rev_user = 0, 0, 1), ifnull(ufg_group, ug_group)
) as a
group by month
SQL

Checking query status...
