Main pl.wiki query 1

SQL

USE plwiki_p;
SELECT
CONCAT("#") AS number,
CONCAT("[[user:",rev_user_text,"|",rev_user_text,"]]") AS rev_user_text,
SUM(CASE WHEN rev_timestamp BETWEEN 20170701000000 AND 20171231235959 THEN 1 ELSE 0 END) AS recent_user_editcount,
SUM(CASE WHEN rev_timestamp BETWEEN 20010101000000 AND 20171231235959 THEN 1 ELSE 0 END) AS overall_user_editcount
FROM revision, user, page
WHERE rev_user = user_id
AND rev_page = page_id
AND page_namespace = 0
GROUP BY rev_user_text
ORDER BY recent_user_editcount DESC
LIMIT 500;
SQL

Checking query status...
