Most active users by bytes on plwiki

SQL

USE plwiki_p;
SELECT
  rev_user_text,
  SUM(byte_change) AS net_sum,
  SUM(ABS(byte_change)) AS abs_sum,
  SUM(byte_change * (byte_change > 0)) AS positive_only_sum,
  SUM(byte_change * (byte_change < 0)) AS negative_only_sum
FROM (
  SELECT
    c.rev_user_text,
    CAST(c.rev_len AS SIGNED) - 
      CAST(IFNULL(p.rev_len, 0) AS SIGNED) AS byte_change
  FROM revision_userindex c
  INNER JOIN page ON page_id = c.rev_page
  LEFT JOIN revision_userindex p ON p.rev_id = c.rev_parent_id
  WHERE 
    page_namespace IN (0) AND
    c.rev_timestamp <= '20151231235959'
) AS byte_changes
GROUP BY rev_user_text;
SQL

Checking query status...
