Untitled query #2050

SQL

	SELECT anon_1.rev_user AS anon_1_rev_user,
            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 revision.rev_user_text AS rev_user,
                    (   cast(revision.rev_len as signed)
                        - cast(coalesce(anon_2.rev_len, 0) as signed)
                    ) AS byte_change
               FROM revision
                        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, 1, 2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15')
                AND revision.rev_user_text IN ('MartinPoulter','Jfdwolff','Pchlondon','JLPhillips','sharkli','Mrjohncummings','Granta03','Pencilspens','Abster14','BeccaParr','Emma M. Jones','Jessicasophiewiki','Superbluefrog','Litar','T27.zaman','KX-alt-edit','Perambulate','Enrychewdoor','Jscammel','Jennyshaw')
                AND revision.rev_timestamp BETWEEN 20140226110000 AND 20140226160000
            ) AS anon_1
      GROUP BY anon_1.rev_user_text
SQL

Checking query status...
