jawikiにおける最多投稿者

SQL

USE jawiki_p;
SELECT user_name AS 利用者名, user_editcount AS 投稿回数, DATE_FORMAT(DATE(user_registration), "%Y-%m-%d") AS 登録日,
DATE_FORMAT(DATE(user_registration), "%Y-%m-%d") AS 登録日, GROUP_CONCAT(ug_group) AS 現在の権限, GROUP_CONCAT(ufg_group) AS 過去の権限,
rev_timestamp as 最終編集日
FROM user
left outer join user_former_groups on user_id = ufg_user
left outer join user_groups on user_id = ug_user
left outer join revision_userindex on user_id = rev_user
where (ufg_group != "bot" OR ufg_group IS NULL) and (ug_group != "bot" OR ug_group IS NULL)
GROUP BY user_id, user_name, user_editcount, user_registration
order by user_editcount desc
LIMIT 10
SQL

Checking query status...
