Scrape Wikidata Item IDs from files in Category:Artworks_missing_digital_representation_of_for_2D_work

SQL

use commonswiki_p;
SELECT concat("M",page_id) AS MID, 'P6243', 
	REPLACE(el_to_path,'/test/?q=%','') AS QID#,  CONCAT("File:",page_title)
FROM page
JOIN externallinks ON page_id=el_from AND el_to_path LIKE '/test/?q=%'
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

SQL

Checking query status...