Anonymous users on plwiki by edit counter

SQL

USE plwiki_p;

SELECT CONCAT("#") AS number, user_id, CONCAT("[[User:",user_name,"|",user_name,"]]") AS user_name,
SUM(when rev_timestamp /*between 20151231235959 and */ > 20150701000000 then 1) AS recent_user_editcount, 
COUNT(rev_id) AS user_editcount
FROM user INNER JOIN revision
ON revision.rev_user = user.user_id
GROUP BY user_name
ORDER BY recent_user_editcount DESC
LIMIT 600




/*


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

WHERE rev_timestamp < 20151231235959
AND rev_timestamp > 20150701000000

GROUP BY user_name
#ORDER BY recent_user_editcount DESC
LIMIT 600

*/
SQL

Checking query status...
