Scrape Wikidata Item IDs from files in Category:Artworks_missing_digital_representation_of_for_2D_work

Fork of Scrape Wikidata Item IDs from {{Artwork}} templates by Jarekt

This query is marked as a draft This query has been published by Jarekt.

SQL

use commonswiki_p;
SELECT concat("M",page_id) AS MID, 'P6243', 
	REPLACE(el_to,'https://reasonator.toolforge.org/test/?q=','') AS QID,  CONCAT("File:",page_title)
FROM page
JOIN externallinks ON page_id=el_from AND el_to LIKE 'https://reasonator.toolforge.org%'
JOIN categorylinks ON page_id=cl_from AND cl_to='Artworks_missing_digital_representation_of_for_2D_work' 
#join templatelinks on page_id=tl_from and tl_namespace = 10  AND (tl_title="Artwork" OR tl_title="Art_Photo" OR tl_title="Object_photo")
WHERE page_namespace = 6 
order by QID asc
limit 20000

SQL

Checking query status...