monthly statistics of jawiki

SQL

use jawiki_p;
select
	user.user_name as 利用者名,
    date( user.user_registration ) as 登録日,
    min( date( rev.rev_timestamp ) ) as 初投稿日,
    max( date( rev.rev_timestamp ) ) as 最終投稿日,
    group_concat( distinct log2.log_params ),
    group_concat( distinct log2.log_action )
from user
inner join revision_userindex as rev on user.user_id = rev.rev_user
left outer join (
  select log.log_title, log.log_params, log.log_action
  from logging_userindex as log
  where log_type = "block" and
  where user.user_name in ( "Tonomuraayuta",
						  "Tanka~jawiki",
						  "魔法陣",
			  			  "和暦除去行為取消し",
						  "和暦除去行為取り消し",
						  "和暦除去行為取消",
						  "武王",
						  "Disputed",
						  "志賀 慶一",
						  "弱",
						  "Inception2010")
) as log2 on user.user_name = log2.log_title
where user.user_name in ( "Tonomuraayuta",
						  "Tanka~jawiki",
						  "魔法陣",
			  			  "和暦除去行為取消し",
						  "和暦除去行為取り消し",
						  "和暦除去行為取消",
						  "武王",
						  "Disputed",
						  "志賀 慶一",
						  "弱",
						  "Inception2010")
group by user.user_id, rev.rev_user, user.user_name, user.user_registration
order by rev.rev_timestamp asc, rev.rev_timestamp asc
SQL

Checking query status...
