Untitled query #21104

SQL

USE trwiki_p;
SELECT
CONCAT("#") AS number,
user_id,
CONCAT("[[user:",user_name,"|",user_name,"]]") AS user_name,
SUM(CASE WHEN rev_timestamp BETWEEN 20160929000000 AND 20170429000000 THEN 1 ELSE 0 END) AS sixmonth_before_the_block,SUM(CASE WHEN rev_timestamp BETWEEN 20170429000000 AND 20170822235959 THEN 1 ELSE 0 END) AS after_the_block,
COUNT(rev_id) AS user_editcount
FROM user INNER JOIN revision
ON revision.rev_user = user.user_id
WHERE rev_timestamp <= 20170822235959 AND after_the_block=0
GROUP BY user_name
ORDER BY sixmonth_before_the_block DESC
LIMIT 1000;
SQL

Checking query status...
