QI supported by WMFR (2013-2014)

SQL

USE commonswiki_p;

SELECT /* SLOW_OK */ COUNT(*)
   FROM 
	   (SELECT /* SLOW_OK */ page.page_title
	   FROM image
	   CROSS JOIN page ON image.img_name = page.page_title 
	   CROSS JOIN categorylinks ON page.page_id = categorylinks.cl_from
	   CROSS JOIN categorylinks c2 ON page.page_id = c2.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 20140701000000 AND 20150701000000
	      AND (c2.cl_to = "Quality_images")
   GROUP BY page.page_title
   ORDER BY img_timestamp ASC) labels;
SQL

Checking query status...
