Reuse of Wiki Loves Africa images across Wikis

SQL

SELECT gil_wiki, cl_to,count(distinct(gil_page)) as reuse
FROM globalimagelinks
WHERE gil_page_namespace_id =0
JOIN page
ON gil_to=page_title
JOIN categorylinks
on cl_from=page_id 
where cl_to in ('Images_from_Wiki_Loves_Africa_2014', 'Images_from_Wiki_Loves_Africa_2015', 
                'Images_from_Wiki_Loves_Africa_2016', 'Images_from_Wiki_Loves_Africa_2017', 
                'Images_from_Wiki_Loves_Africa_2019', 'Images_from_Wiki_Loves_Africa_2020', 
                'Images_from_Wiki_Loves_Africa_2021', 'Images_from_Wiki_Loves_Africa_2022', 
                'Images_from_Wiki_Loves_Africa_2023' )
group by gil_wiki,cl_to
order by reuse DESC

SQL

Checking query status...