Hywiki users by added and deleted bytes

SQL

USE hywiki_p;


SELECT anon_1.rev_actor AS anon_1_rev_actor,
       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,
       user_registration,
       user_name
FROM
  (SELECT actor_name AS rev_actor,
          (cast(revision.rev_len AS signed) - cast(coalesce(anon_2.rev_len, 0) AS signed)) AS byte_change
   FROM revision
   JOIN actor ON revision.rev_actor = actor_id
   INNER JOIN page ON page.page_id = revision.rev_page
   LEFT OUTER JOIN
     (SELECT revision.rev_id AS rev_id,
             revision.rev_len AS rev_len
      FROM revision) AS anon_2 ON revision.rev_parent_id = anon_2.rev_id
   WHERE page.page_namespace IN (0) ) AS anon_1
JOIN USER ON user_id=rev_actor
GROUP BY user_name
ORDER BY net_sum DESC
LIMIT 100;
SQL

Checking query status...
