monthly statistics of jawiki

SQL

use jawiki_p;
select
  a.month,
  case
    when Neditor_include_a_user is null then 0
    else Neditor_include_a_user
  end,
  
  case
    when Neditor_exclude_a_user is null then 0
    else Neditor_exclude_a_user
  end,
  
  case
    when Nedits is null then 0
    else Nedits
  end,
  
  case
    when Nedits_by_r_user is null then 0
    else Nedits_by_r_user
  end,
  
  case
    when Nedits_by_a_user is null then 0
    else Nedits_by_a_user
  end
  
from (
  select
    left( rev_timestamp, 6 ) as month,
    count( distinct rev_user ) as Neditor_include_a_user
  from revision
  group by left(rev_timestamp, 6)
) as a

left outer join (
  select
    left( rev_timestamp, 6 ) as month,
    count( distinct rev_user ) as Neditor_exclude_a_user
  from revision
  where
    rev_user != 0
  group by left(rev_timestamp, 6)
) as b on a.month = b.month

left outer join (
  select
    left( rev_timestamp, 6 ) as month,
    count(*) as Nedits
  from revision
  group by left(rev_timestamp, 6)
) as c on a.month = c.month

left outer join (
  select
    left( rev_timestamp, 6 ) as month,
    count(*) as Nedits_by_r_user
  from revision
  where
    rev_user != 0
  group by left(rev_timestamp, 6)
) as d on a.month = d.month

left outer join (
  select
    left( rev_timestamp, 6 ) as month,
    count(*) as Nedits_by_a_user
  from revision
  where
    rev_user = 0
  group by left(rev_timestamp, 6)
) as e on a.month = e.month
SQL

Checking query status...
