Untitled query #1905

SQL

USE tewiki_p;    
SELECT tewiki_p.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 tewiki_p.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 tewiki_p.revision
                        INNER JOIN
                    tewiki_p.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 tewiki_p.page.page_namespace IN ('0')
                AND tewiki_p.revision.rev_user IN ('Nrgullapalli',
'Bhaskaranaidu',
'శ్రీరామమూర్తి',
'JVRKPRASAD',
'T.sujatha',
'Pavan santhosh.s',
'Kvr.lohith',
'Rajasekhar1961',
'సుల్తాన్ ఖాదర్',
'Praveen Grao',
'C.Chandra Kanth Rao',
'Pranayraj1985',
'స్వరలాసిక',
'Arjunaraoc',
'Meena gayathri.s',
'అహ్మద్ నిసార్',
'Palagiri',
'YVSREDDY')
                AND revision.rev_timestamp BETWEEN '2014-01-01' AND '2014-12-31'
            ) AS anon_1
      GROUP BY anon_1.rev_user
SQL

Checking query status...
