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;