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_compat #by joining page with image table we can get the metadata from the image
ON page.page_title=image_compat.img_name
JOIN geo_tags #by joining geo_tags with image table we can get the coordinates of the image
ON geo_tags.gt_page_id=page.page_id
WHERE categorylinks.cl_to='Images_from_Wiki_Loves_Monuments_2019' #target category
limit 10
SQL

Checking query status...
