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

SQL

# Inspired by Jan Ainali (WMSE)'s querry: https://quarry.wmflabs.org/query/4646
USE commonswiki_p;
SELECT 
		#CONCAT (iw.iw_prefix, ":", gil.gil_page_title) AS page,
        gil.gil_wiki AS Project,
        gil.gil_page_title AS Page,
       	page.page_title AS Image
       	
            FROM image
            CROSS JOIN page ON image.img_name = page.page_title
            CROSS JOIN categorylinks ON page.page_id = categorylinks.cl_from
            CROSS JOIN globalimagelinks gil ON gil.gil_to = image.img_name
            
            #LEFT JOIN interwiki iw ON iw.iw_wikiid = gil.gil_wiki
            WHERE
            
            	# Filter by category: Images from Wiki Loves Africa 2017 in Côte d'Ivoire
                (categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Côte_d'Ivoire")
               
               # Filter after 30 October 2017
                AND image.img_timestamp > 20170930000000 
;

USE commonswiki_p;
SELECT 
		#CONCAT (iw.iw_prefix, ":", gil.gil_page_title) AS page,
        
       	COUNT(page.page_title) AS total_reused_images
       	
            FROM image
            CROSS JOIN page ON image.img_name = page.page_title
            CROSS JOIN categorylinks ON page.page_id = categorylinks.cl_from
            CROSS JOIN globalimagelinks gil ON gil.gil_to = image.img_name
            
            #LEFT JOIN interwiki iw ON iw.iw_wikiid = gil.gil_wiki
            WHERE
            
            	# Filter by category: Images from Wiki Loves Africa 2017 in Côte d'Ivoire
                (categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Côte_d'Ivoire")
               
               # Filter after 30 October 2017
                AND image.img_timestamp > 20170930000000 
                GROUP BY page
;
SQL

Checking query status...
