2013 pixel count

SQL

USE commonswiki_p;

SELECT /* SLOW_OK */ 
	SUM(image.img_size) AS 'sum_size',
	SUM(image.img_width*image.img_height) AS 'sum_pixel'
FROM image
CROSS JOIN page ON image.img_name = page.page_title
CROSS JOIN categorylinks ON page.page_id = categorylinks.cl_from
LEFT JOIN oldimage ON image.img_name = oldimage.oi_name AND oldimage.oi_timestamp = (SELECT MIN(o.oi_timestamp) FROM oldimage o WHERE o.oi_name = image.img_name)
WHERE
    categorylinks.cl_to = 'Media_supported_by_Wikimedia_France'
    AND IF(oldimage.oi_timestamp IS NULL, img_timestamp, oldimage.oi_timestamp)  BETWEEN 20131001000000 AND 20140101000000;
SQL

Checking query status...
