Untitled query #12797

SQL

USE arwiki_p;
SELECT 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
       	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 edits_bytes DESC
LIMIT 50;
SQL

Checking query status...
