Reused Images from Wiki Loves Africa 2017 in Côte d'Ivoire

SQL

# Inspired Jan Ainali (WMSE) querry: https://quarry.wmflabs.org/query/4646
USE commonswiki_p;
SELECT /* SLOW_OK */
                COUNT(page.page_title) AS total_usage,
               CONCAT(gil.gil_wiki, gil.gil_page_title) AS page,
                COUNT(DISTINCT page.page_title) AS Images uploaded,
                gil.gil_wiki AS Project
            FROM image
            LEFT JOIN page ON image.img_name = page.page_title
            LEFT JOIN categorylinks ON page.page_id = categorylinks.cl_from
            LEFT JOIN globalimagelinks gil ON gil.gil_to = image.img_name
            WHERE
                (categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Côte_d'Ivoire")
                # Filter within the range 30 October and 30 November 2017
                AND image.img_timestamp > 20170930000000 
;
SQL

Checking query status...
