Untitled query #43740

SQL

USE commonswiki_p;
SELECT *
FROM globalimagelinks 
LEFT JOIN page 
ON globalimagelinks.gil_to = page.page_title
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 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
LEFT JOIN categorylinks
ON categorylinks.cl_from = page.page_id
WHERE categorylinks.cl_to='Images_from_Wiki_Loves_Monuments_2019' 
AND gil_wiki = 'wikidatawiki'
SQL

Checking query status...
