Untitled query #18596

SQL

use tewiki_p;
select user_id from user where user_name="JVRKPRASAD";

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 revision.rev_user IN (15991)
            ) AS user1
       JOIN user ON user_id=rev_user
       GROUP BY user1.rev_user, LEFT(user1.rev_timestamp, 6)
;
SQL

Checking query status...
