USE plwiki_p;

SELECT CONCAT("[[User:",user_name,"|",user_name,"]]") AS user_name, COUNT(rev_id) AS user_recent_editcount, user_editcount, ug_group

FROM user

INNER JOIN user_groups

ON user_groups.ug_user = user.user_id

INNER JOIN revision

ON revision.rev_user = user.user_id

WHERE rev_timestamp > 20140601000000 AND rev_timestamp < 20150101000000 AND ug_group != "bot"

GROUP BY user_name

ORDER BY user_recent_editcount

LIMIT 600