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
JOIN
    page ON categorylinks.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
WHERE
    categorylinks.cl_to = 'Images_from_Wiki_Loves_Monuments_2023_in_Italy_-_Tuscany'
    AND (cl2.cl_to IS NULL OR cl2.cl_to != 'Images_from_Wiki_Loves_Monuments_2023_in_Italy_-_Tuscany_-_semifinalists')
ORDER BY
    size DESC;
SQL

Checking query status...
