Most active users by bytes in this month (arwiki)

SQL

USE arwiki_p;
SELECT CONCAT("[[مستخدم:",user_name,"|",user_name,"]]") AS user_name,
        SUM(CAST(rev.rev_len as signed) - CAST(COALESCE(parent.rev_len,0) as signed)) AS edits_bytes,
		COUNT(rev.rev_id) AS edit_count
	FROM arwiki_p.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 BETWEEN 20160926000000 AND 20161003000000
    AND page_namespace = 0
    AND user_name NOT REGEXP '[Bb]ot'
    AND rev.rev_comment not like "%استرجاع تعديلات%"
    AND rev.rev_comment not like "%رفض التغيير%"
    AND rev.rev_comment not like "%[[وب:رجوع|الرجوع]] عن%"
GROUP BY user_name
ORDER BY edits_bytes DESC
LIMIT 500;
SQL

Checking query status...
