SQL
x
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 OUTER 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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.