-- SELECT rev_page  FROM revision WHERE rev_id=263989

-- > page: 2221092

​

SELECT 

    rev.rev_actor AS actor_id,

    COUNT(rev.rev_actor) AS edits_num,

    SUM(abs(rev.rev_len - COALESCE(parent.rev_len, 0))) AS total_len_difference

FROM revision_userindex rev

LEFT JOIN revision parent 

    ON rev.rev_parent_id = parent.rev_id

WHERE rev.rev_page = 2221092 

    AND rev.rev_minor_edit = 0 

    AND rev.rev_id <= 263989

GROUP BY rev.rev_actor

ORDER BY 2 desc, 3 desc, 1 asc

;

​