Wikimédia France - 2013-2014 round2 - All - Uploader count

SQL

use commonswiki_p;
SELECT IF(oi_user_text IS NULL, img_user_text, oi_user_text) AS uploader, COUNT(page_title) AS pictures
    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 page.page_id=categorylinks.cl_from 
        AND image.img_name = page.page_title
        AND .categorylinks.cl_to = "Media_supported_by_Wikimedia_France"
        AND IF(oi_timestamp IS NULL, img_timestamp, oi_timestamp) BETWEEN 20140701000000 AND 20150701000000
    GROUP BY uploader
    ORDER BY pictures DESC;

SQL

Checking query status...