Collect all images and uploaders for Wiki Loves Monuments

SQL

USE commonswiki_p;
SELECT
	image.img_name AS filename,
    page.page_id AS page_id,
    image.img_timestamp AS timestamp,
    actor.actor_name AS uploader,
    tl_title AS template
FROM
	page
INNER JOIN templatelinks ON page.page_id = tl_from
INNER JOIN image ON page.page_title = img_name
INNER JOIN actor ON actor.actor_id = image.img_actor
WHERE 
	tl_namespace = 10 AND
    tl_from_namespace = 6 AND
    tl_title in ('Wiki_Loves_Monuments_2010', 
                 'Wiki_Loves_Monuments_2011', 
                 'Wiki_Loves_Monuments_2012', 
                 'Wiki_Loves_Monuments_2013', 
                 'Wiki_Loves_Monuments_2014', 
                 'Wiki_Loves_Monuments_2015', 
                 'Wiki_Loves_Monuments_2016', 
                 'Wiki_Loves_Monuments_2017', 
                 'Wiki_Loves_Monuments_2018', 
                 'Wiki_Loves_Monuments_2019')
SQL

Checking query status...
