USE trwiki_p;

SELECT

CONCAT("[[Kullanıcı:",user_name,"|",user_name,"]]") AS "Kullanıcı",

SUM(CASE WHEN rev_timestamp BETWEEN 20161100000000 AND 20161200000000 THEN 1 ELSE 0 END) AS recent_user_editcount

FROM user INNER JOIN revision

ON revision.rev_user = user.user_id

INNER JOIN page

ON page.page_id = revision.rev_page

WHERE rev_timestamp >= 20000000000000

AND user_registration BETWEEN 20161200000000 AND 20171200000000

AND page.page_namespace = 0

GROUP BY user_name

ORDER BY recent_user_editcount DESC

LIMIT 30;