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 過去の権限
FROM (user join user_former_groups on user_id = ufg_user)
           join user_groups on user_id = ug_user
#where (ufg.ufg_group != "bot" OR ufg.ufg_group IS NULL)and(ug.ug_group != "bot" OR ug.ug_group IS NULL)
where user_name = "軽快"
GROUP BY user_id, user_name, user_editcount, user_registration
order by user_editcount desc
LIMIT 10
SQL

Checking query status...
