Most active users by bytes in this year (trwiki)

Fork of Most active users by bytes in this year (trwiki) by Bulgu

This query is marked as a draft This query has been published by Anerka.

SQL

SELECT user_name,
        SUM(abs(CAST(rev.rev_len as signed) - CAST(COALESCE(parent.rev_len,0) as signed))) AS edits_bytes,
		COUNT(rev.rev_id) AS edit_count,  concat("tr.wikipedia.org/wiki/Özel:Katkılar/",replace(user_name," ","_")) as url
	FROM revision rev
    	INNER JOIN user
             ON user_id = rev.rev_user
        LEFT OUTER JOIN revision parent
       		ON rev.rev_parent_id = parent.rev_id
        JOIN page
        	ON rev.rev_page = page_id
    WHERE page_namespace = 0
    AND rev.rev_timestamp > 20170000000000 
    AND user_name NOT REGEXP '[Bb]ot'
GROUP BY user_name having edits_bytes > 1000
ORDER BY edits_bytes DESC
LIMIT 100;

SQL

Checking query status...