-- 2221092

-- SELECT rev_page  FROM revision WHERE rev_id=263989

-- , count(rev_actor) as `edits_num`, sum(rev_len) as `total_len`

SELECT 

    rev.rev_actor AS actor_id,

    rev.rev_len,

    COALESCE(parent.rev_len, 0) AS parent_len,

    rev.rev_len - COALESCE(parent.rev_len, 0) AS 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;

​