use commonswiki_p;

SELECT page_title, img_user_text AS uploader, CONCAT('https://commons.wikimedia.org/wiki/File:', page_title) AS link

    FROM page

        JOIN categorylinks AS cl1 ON page_id=cl1.cl_from

        JOIN categorylinks AS cl2 ON page_id=cl2.cl_from 

        JOIN image ON image.img_name = page.page_title

    WHERE cl1.cl_to="Media_supported_by_Wikimedia_France"

        AND cl2.cl_to="Featured_pictures_on_Wikimedia_Commons"

        AND img_timestamp BETWEEN 20140701000000 AND 20150701000000

    ORDER BY uploader DESC;