Untitled query #12797

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 byte_count, COUNT(rev.rev_id) as edit_count
FROM arwiki_p.revision rev
    	INNER JOIN ep_articles
        	ON rev.rev_page = article_page_id
        LEFT OUTER JOIN revision parent #self join for parent diff size
       		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 20160928000000 AND 20161000000000
AND parent.rev_timestamp BETWEEN 20160928000000 AND 20161000000000
AND user_name Like 'Mervat_Salman'
GROUP BY user_name
#having byte_count > 0
ORDER BY byte_count DESC
LIMIT 50;
SQL

Checking query status...
