Untitled query #18607

SQL

use tewiki_p;
SELECT user1.rev_user AS user1_rev_user,
            sum(user1.byte_change) AS net_sum,
            sum(abs(user1.byte_change)) AS absolute_sum,
            sum(CASE
                    WHEN (user1.byte_change > 0)
                    THEN user1.byte_change
                    ELSE 0 END
               ) AS positive_only_sum,
            sum(CASE
                    WHEN (user1.byte_change < 0)
                    THEN user1.byte_change
                    ELSE 0 END
               ) AS negative_only_sum,
            user_registration, 
            rev_user_text,
            LEFT(user1.rev_timestamp, 6) as monthYear
       FROM (SELECT revision.rev_user AS rev_user,
                    (   cast(revision.rev_len as signed)
                        - cast(coalesce(user2.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 user2 ON revision.rev_parent_id = user2.rev_id
              WHERE page.page_namespace IN ('0') AND page.page_id in (105968,105228,96066,53283,63338,113095,102365,106475,102139,106769,105009,109204,100930,111401,102535,93352,98965,82007,99479,64952,106045,107028,221547,65599,101589,40147,106188,111472,111853,70019,108245,74656,92785,94502,96847,99648,100812,94503,85550,96806,100124,72868,102016,107293,102366,89309,59579,111359,105682,108183,109036,105303,105358,106020,111270,112635,73847,111042,107514,235378,101852,105697,67122,106554,105969,9841,106694,99712,97916,65244,106714,235398,111583)
                AND revision.rev_user_text="రవిచంద్ర"
            ) AS user1
       JOIN user ON user_id=rev_user
       GROUP BY user1.rev_user, LEFT(user1.rev_timestamp, 6)
;
SQL

Checking query status...
