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 最終投稿日
    log.log_params as 設定値
from user
left outer join logging_logindex as log on user.user_name = log.log_title
left outer 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
    log.log_type = "block"
group by user.user_id, user.user_name, user.user_registration
order by 初投稿日 asc, 最終投稿日 asc
SQL

Checking query status...
