All Images and Metadata from WLM 2019

Fork of All Images and Metadata from WLM 2019 by Miriam (WMF)

This query is marked as a draft This query has been published by Miriam (WMF).

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 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
AND page_namespace = 6
LIMIT 10

SQL

Checking query status...