bytes_added a la wikimetric

SQL

     SELECT anon_1.rev_user AS anon_1_rev_user,
            sum(anon_1.byte_change) AS net_sum,
            sum(abs(anon_1.byte_change)) AS absolute_sum,
            sum(CASE
                    WHEN (anon_1.byte_change > 0)
                    THEN anon_1.byte_change
                    ELSE 0 END
               ) AS positive_only_sum,
            sum(CASE
                    WHEN (anon_1.byte_change < 0)
                    THEN anon_1.byte_change
                    ELSE 0 END
               ) AS negative_only_sum
       FROM (SELECT enwiki_p.revision_userindex.rev_user AS rev_user,
                    (   cast(revision_userindex.rev_len as signed)
                        - cast(coalesce(anon_2.rev_len, 0) as signed)
                    ) AS byte_change
               FROM enwiki_p.revision
                        INNER JOIN
                    page        ON page.page_id = revision_userindex.rev_page
                        LEFT OUTER JOIN
                    (SELECT revision_userindex.rev_id AS rev_id,
                            revision_userindex.rev_len AS rev_len
                       FROM enwiki_p.revision_userindex
                    ) AS anon_2 ON revision.rev_parent_id = anon_2.rev_id
              WHERE page.page_namespace IN ('0')
                AND revision_userindex.rev_user IN (319203)
                AND revision_userindex.rev_timestamp BETWEEN '2014-06-18' AND '2014-07-18'
            ) AS anon_1
      GROUP BY anon_1.rev_user
SQL

Checking query status...
