Top contributions for given user on English Wikipedia

Fork of Top contributions for "Harej" on English Wikipedia by EpochFail

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

Two queries.  The first gathers the top 10 pages by the number of bytes added by User:Harej.  The second gathers the top 10 Encyclopedia articles by the same criteria.

SQL

SELECT 
	page_id,
    page_namespace,
    page_title, 
    SUM(IF(CAST(revision.rev_len AS INT) - IFNULL(CAST(parent.rev_len AS INT), 0) > 0, 
           CAST(revision.rev_len AS INT) - IFNULL(CAST(parent.rev_len AS INT), 0), 0)) AS bytes_added
FROM revision_userindex AS revision
LEFT JOIN revision_userindex AS parent ON
	revision.rev_parent_id = parent.rev_id
INNER JOIN page ON revision.rev_page = page.page_id
WHERE 
	revision.rev_user_text = "Aceus0shrifter" AND
    page.page_namespace = 0
GROUP BY 1,2,3
ORDER BY bytes_added DESC
LIMIT 100;

SQL

Checking query status...