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 AS rev_user,
		(cast(rev.rev_len as signed) - cast(coalesce(anon_2.rev_len, 0) as signed)) AS byte_change
	FROM 
  			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 
                 	rev.rev_id AS rev_id,
					rev.rev_len AS rev_len	
				FROM 	
                 	(SELECT * FROM revision 
             		WHERE revision.rev_timestamp BETWEEN '2014-12-01' AND '2015-01-01') AS rev
               	) 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...
