# DESCRIBE arwiki_p.revision;

​

SELECT user_name, /*user_id, rev.rev_id, rev.rev_parent_id, rev.rev_len AS rev_len, parent.rev_len AS parent_rev_len,*/ SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) AS edit_size, COUNT(rev.rev_id) as edit_bytes

    FROM arwiki_p.user

        JOIN arwiki_p.revision rev

        ON user_id = rev.rev_user

        JOIN arwiki_p.revision parent #self join for parent length

        ON rev.rev_parent_id = parent.rev_id

    WHERE user_name = "TFlanagan-WMF"

    GROUP BY user_name