Untitled query #86712

SQL

SELECT 
    page.page_title, 
    c2.cl_sortkey_prefix AS rijksmonument, 
    img.img_name, 
    img.img_size, 
    img.img_width, 
    img.img_height, 
    img.img_bits, 
    img.img_media_type, 
    img.img_major_mime, 
    img.img_minor_mime, 
    img.img_timestamp, 
    img.img_sha1
FROM 
    page
JOIN categorylinks AS c1 ON page.page_id = c1.cl_from AND c1.cl_to = 'Images_from_the_Rijksdienst_voor_het_Cultureel_Erfgoed'
JOIN categorylinks AS c2 ON page.page_id = c2.cl_from AND c2.cl_to = 'Rijksmonumenten_with_known_IDs'
JOIN image AS img ON page.page_title = img.img_name
WHERE 
    page.page_namespace = 6
    AND page.page_is_redirect = 0;
SQL

Checking query status...
