Collect images and uploaders for Wiki Loves Monuments 2021 within timeframe

SQL

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,
    categorylinks.cl_to AS cl_to
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
INNER JOIN categorylinks ON page.page_id = categorylinks.cl_from
WHERE 
	tl_namespace = 10 AND
    tl_from_namespace = 6 AND
    tl_title in ('Wiki_Loves_Monuments_2021') AND
    image.img_timestamp > 20210924000000 AND
    image.img_timestamp < 20211101000000 AND
    categorylinks.cl_type = "file" AND
    categorylinks.cl_to LIKE 'Images_from_Wiki_Loves_Monuments_2021 in %'

SQL

Checking query status...