Untitled query #24741

SQL

use jawiki_p;/*
select
  month,
  sum( case is_registered when 0 then edit_count else 0 end ) as anonymous_editor,
  sum( case when (is_registered = 1 and is_bot = 0) then edit_count else 0 end ) as registered_editor,
  sum( case is_bot when 1 then edit_count else 0 end ) as bot_editor
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( exists rev_user_text ) 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)
  order by null/*
) as a
group by month;*/
SQL

Checking query status...
