Untitled query #77295

SQL

SELECT
    page.page_title AS file_title,
    image.img_name AS file_name,
    image.img_timestamp AS upload_timestamp,
    image.img_size AS size
FROM
    categorylinks AS cl1
JOIN
    page ON cl1.cl_from = page.page_id
JOIN
    imagelinks ON page.page_title = imagelinks.il_to
JOIN
    image ON imagelinks.il_to = image.img_name
LEFT JOIN
    categorylinks AS cl2 ON image.img_name = cl2.cl_to
    AND cl2.cl_to = 'Images_from_Wiki_Loves_Monuments_2023_in_Italy_-_Tuscany_-_semifinalists'
WHERE
    cl1.cl_to = 'Images_from_Wiki_Loves_Monuments_2023_in_Italy_-_Tuscany'
    AND cl2.cl_to IS NULL
ORDER BY
    size DESC;
SQL

Checking query status...
