Untitled query #43763

SQL

use cswiki_p;
SELECT
	rev_actor,
    SUM(ABS(byte_change)) AS absolute_sum,
    SUM(CASE
        WHEN (byte_change>0)
        THEN byte_change
        ELSE 0 END
    ) AS positive_sum,
    SUM(CASE
        WHEN (byte_change<0)
        THEN ABS(byte_change)
        ELSE 0 END
    ) AS negative_sum
FROM
(
  SELECT revision.rev_actor, cast(revision.rev_len as signed)-cast(coalesce(old_revision.rev_len, 0) as signed) AS byte_change
  FROM revision
  JOIN actor_revision ON actor_id=revision.rev_actor
  LEFT JOIN revision AS old_revision ON old_revision.rev_id=revision.rev_parent_id
  WHERE actor_name IN ("Martin Urbanec")
  AND revision.rev_timestamp > "20181219160000" AND revision.rev_timestamp < "20181219183000"
) AS anon_1 GROUP BY rev_actor;
SQL

Checking query status...
