monthly statistics of jawiki

SQL

use jawiki_p;
select
  user2.username as 利用者名,
  user2.registered as 登録日,
  user2.first_edit as 初投稿日,
  user2.last_edit as 最終投稿日,
  concat( 
    date( log.log_timestamp ), "に",
    case
    	when log.log_action <> "unblock" then concat( log.log_params, "の")
    	else ""
    end,
    case log.log_action
      when "block" then "ブロック"
      when "reblock" then "再ブロック"
      when "unblock" then "ブロック解除"
      else null
     end
  ) as ブロック記録
from (
  select
    user.user_name as username,
    date( user.user_registration ) as registered,
    min( date( rev.rev_timestamp ) ) as first_edit,
    max( date( rev.rev_timestamp ) ) as last_edit
  from user
  inner join revision_userindex as rev on user.user_id = rev.rev_user
  where 
    (user.user_name = "Tonomuraayuta" or
    user.user_name = "Tanka~jawiki" or
    user.user_name = "魔法陣" or
    user.user_name = "和暦除去行為取消し" or
    user.user_name = "和暦除去行為取消" or
    user.user_name = "和暦除去行為取り消し" or
    user.user_name = "武王" or
    user.user_name = "Disputed" or
    user.user_name = "志賀 慶一" or
    user.user_name = "弱" or
    user.user_name = "Inception2010") and
    rev.rev_page not in ("3301754", "2684401", "2696094", "3130050", "3405591", "3193264",
                         "2101263", "1989399", "2636044", "3383671", "2654335", "2567357")
  group by user.user_id, rev.rev_user, user.user_name, user.user_registration
) as user2
left outer join (
  select log2.log_type as type, log2.log_action, log2.log_title as blocked_user, log2.log_timestamp, log2.log_params
  from logging_userindex as log2
  where 
    (log2.log_title = "Tonomuraayuta" or
    log2.log_title = "Tanka~jawiki" or
    log2.log_title = "魔法陣" or
    log2.log_title = "和暦除去行為取消し" or
    log2.log_title = "和暦除去行為取消" or
    log2.log_title = "和暦除去行為取り消し" or
    log2.log_title = "武王" or
    log2.log_title = "Disputed" or
    log2.log_title = "志賀 慶一" or
   	log2.log_title = "弱" or
    log2.log_title = "Inception2010") and
	log_type = "block"
) as log on user2.username = log.blocked_user
order by user2.registered, user2.first_edit, user2.last_edit, log.log_timestamp
SQL

Checking query status...
