Select all categories for all images in WLM 2019

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
LEFT JOIN imagelinks 
ON page.page_title=imagelinks.il_to
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 page_id in (SELECT cl_from FROM categorylinks where cl_to='Images_from_Wiki_Loves_Monuments_2019') #target category
AND page_namespace = 6

SQL

Checking query status...