Untitled query #86726

SQL

SELECT 
    page.page_title, 
    c2.cl_sortkey_prefix AS rijksmonument, 
    img.img_name, 
    img.img_timestamp, 
    actor.actor_name AS author, -- Haal de actor-naam (auteur/uploader) op
    comment.comment_text AS description -- Haal de beschrijving op
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
JOIN actor ON img.img_actor = actor.actor_id -- Koppel de actor voor de auteur/uploader
LEFT JOIN comment ON img.img_description_id = comment.comment_id -- Koppel de beschrijving via de comment-tabel
JOIN templatelinks AS tl ON page.page_id = tl.tl_from
JOIN linktarget AS lt ON tl.tl_target_id = lt.lt_id
WHERE 
    page.page_namespace = 6
    AND page.page_is_redirect = 0
    AND lt.lt_title = 'Information' -- Selecteer afbeeldingen met het 'Information'-sjabloon
ORDER BY page.page_title
LIMIT 100; -- Limiteer het aantal resultaten tot 100
SQL

Checking query status...
