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( log.data, separator '<br />' ) as 設定値
from user
inner join revision_userindex as rev on user.user_id = rev.rev_user
left outer join
(
  select log2.log_title as blocked_user, log2.log_params as data
  from logging_logindex as log2
  where
  	log2.log_type = "block" AND
 	log2.log_title IN ("Tonomuraayuta", "Tanka~jawiki", "魔法陣",
						"和暦除去行為取消し","和暦除去行為取り消し",
						"和暦除去行為取消", "武王", "Disputed",
          				"志賀 慶一", "弱", "Inception2010")
) as log on user.user_name = log.blocked_user
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 初投稿日 asc, 最終投稿日 asc
SQL

Checking query status...
