Untitled query #15401

SQL

USE tewiki_p;
SELECT anon_1.rev_user_text AS anon_1_rev_user_text,
            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, revision.rev_user_text AS rev_user_text,
                    (   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
FROM page AS p2 WHERE p2.page_namespace = 0 AND p2.page_title 
IN (SELECT page_title 
    FROM page
    WHERE page_id 
	IN (SELECT cl_from 
		FROM categorylinks
    	WHERE cl_to = "ఆంధ్రప్రదేశ్,_తెలంగాణల్లోని_పర్యాటక_ప్రదేశాలు,_చారిత్రక_స్థలాలు_ఎడిటథాన్_వ్యాసాలు"
) 

                AND revision.rev_timestamp > 20161005000000
                AND revision.rev_timestamp < 20161101000000
            ) AS anon_1 
                 )

;
SQL

Checking query status...
