Untitled query #43323

SQL

USE commonswiki_p;
SELECT *
FROM categorylinks #by joining this with the page table we can get the link between image and category Wiki Loves Monuments
LEFT JOIN page 
ON categorylinks.cl_from = page.page_id
LEFT JOIN image #by joining page with image table we can get the metadata from the image
ON page.page_title=image.img_name
JOIN page_props #by joining comment with image table we can get the description of the image
ON page.page_id=page_props.pp_page
WHERE categorylinks.cl_to='Images_from_Wiki_Loves_Monuments_2019' #target category
AND page_namespace = 6
limit 10
SQL

Checking query status...
