use cswiki_p;

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 revision.rev_user 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')

                AND revision.rev_user IN (32153,85654,124626,146865,161915,168874,222926,238009,250193,269296,269297,269299,269300,269301,270020,270383,270658,270660,270661,270662,270663,270664,270667,270668,270757,270970,272895,273148,273720,273851,273852,273853,273854,273855,273857,273860,273861,274057,274058,274678,274680,274681,274682,275473,276259,276463,277996,281884,281885,281886,281887,281993,281995,281998,281999,282254,282255,282256,282257,282258,282626,282875,282876,282877,282878,282885,282920,283011,283012,283014,283025,283032,283036,283236,283817,283818,283935,283936,283970,284780,284781,284797,284984,285820,286580,287443,289010,289011,289012,289013,289842,289843,289844,289848,289973,290669,290678,290715,292694,292695,292696,292697,293510,293549,293681,293916,293917,295186,296058,296976,296980,296981,297089,297090,300715,300716,300717,300718,300719,300722,300723,300724,300725,314096,314110,314135,314143,314293,314315,316254,317467,317499,317500,317501,321898,324143,324144,324145,324146,324148,324177,324185,324232,324244,324248,324477,325789,325790,325792,326287,326291,326997,326999,327003,327985,327987,327988,327990,327993,327994,327996,329525,330726,330843,330844,330846,330849,330851,330953,330961,330962,330963,330966,330967,330968,330969,331121,331435,331436,331438,331439,331440,331441,331442,331443,331444,331445,331446,331447,331449,331450,331451,331962,332089,332111,332169,332385,332881,334943,334944,334945,334947,335692,335796,335801,335804,335805,335841,335887,335902,335906,335907,335955,335990,336005,336008,336101,336112,340176,344090,347285,347668,347748,348238,348371,348372,348373,348377,348398,348399,348401,348695,348710,348716,348717,349219,105996,232317,271338,351385,351397,351409,351879,351882,351883,352580,352788,352789,352790,352791,352792,353300,353600)

            ) AS anon_1

      GROUP BY anon_1.rev_user

;