Most active users by edits on plwiki in last 12 months

SQL

USE plwiki_p;
SELECT CONCAT("#") AS number, user_id, CONCAT("[[User:",user_name,"|",user_name,"]]") AS user_name,
COUNT(rev_id) AS recent_user_editcount, user_editcount,
ug_group

#$wgGroupPermissions ?

#FROM user, revision, user_groups
#WHERE revision.rev_user = user.user_id
#AND user_groups.ug_user = user.user_id

#FROM user LEFT JOIN revision ?

FROM user INNER JOIN revision
ON revision.rev_user = user.user_id
INNER JOIN user_groups
ON user_groups.ug_user = user.user_id

WHERE rev_timestamp < 20151231235959
AND rev_timestamp > 20150701000000
#WHERE rev_timestamp < 20150630235959
#AND rev_timestamp > 20150101000000

AND ug_group != "bot"

GROUP BY user_name
ORDER BY recent_user_editcount DESC
LIMIT 600;

SQL

Checking query status...