Most active users by articles on plwiki

SQL

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

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

GROUP BY user_name
#ORDER BY recent_user_editcount DESC
LIMIT 600

UNION

SELECT CONCAT("#") AS number, user_id, CONCAT("[[User:",user_name,"|",user_name,"]]") AS user_name,
COUNT(rev_id) AS user_editcount

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

GROUP BY user_name
#ORDER BY recent_user_editcount DESC
LIMIT 600
SQL

Checking query status...
