Untitled query #2052

SQL

#SELECT COUNT(*) AS n FROM revision WHERE revision.rev_timestamp BETWEEN '2013-06-18' AND '2014-07-18' LIMIT 10
#SELECT page.page_namespace#COUNT(*) AS n 
#FROM page
#	revision INNER JOIN page ON page.page_id = revision.rev_page 
#WHERE 
#	page.page_namespace IN (1,2,3,4,5,7,8,9,10,11,12,13,14,15)
#LIMIT 10

SELECT
	anon_1.rev_user,
	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
		rev.rev_user_text AS rev_user,
		(cast(rev.rev_len as signed) - cast(coalesce(anon_2.rev_len, 0) as signed)) AS byte_change
	FROM 
  			(SELECT revision.rev_len, revision.rev_user_text, revision.rev_page, revision.rev_parent_id FROM revision 
             WHERE revision.rev_timestamp BETWEEN 20140226110000 AND 20140226160000) AS rev
  		INNER JOIN 
  			( SELECT page.page_id FROM page WHERE page.page_namespace IN (0,1,2,3,4,5,7,8,9,10,11,12,13,14,15) ) AS pag
  		ON pag.page_id = rev.rev_page
			LEFT OUTER JOIN
				(SELECT 
                 	revision.rev_id AS rev_id,
					revision.rev_len AS rev_len	
				FROM revision WHERE revision.rev_timestamp BETWEEN 20140226110000 AND 20140226160000
                                 AND revision.rev_user_text IN ("MartinPoulter","Jfdwolff","Pchlondon","JLPhillips","sharkli","Mrjohncummings","Granta03","Pencilspens","Abster14","BeccaParr","Emma_M._Jones","Jessicasophiewiki","Superbluefrog","Litar","T27.zaman","KX-alt-edit","Perambulate","Enrychewdoor","Jscammel","Jennyshaw")
                    ) AS anon_2 ON rev.rev_parent_id = anon_2.rev_id
	) AS anon_1
GROUP BY anon_1.rev_user
LIMIT 1
SQL

Checking query status...
