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,

            user_registration, 

            rev_user_text,

            LEFT(anon_1.rev_timestamp, 6) as monthYear,

            COUNT(anon_1.rev_user) as editcount

       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,

                    rev_timestamp,

                    rev_user_text

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

            ) AS anon_1

       JOIN user ON user_id=rev_user

       GROUP BY anon_1.rev_user, LEFT(anon_1.rev_timestamp, 6)

;