Capture QuickStatement external links of {{Creator}} templates

Fork of Capture QuickStatement external links of {{Artwork}} templates by Jarekt

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

SQL

use commonswiki_p;
#SELECT concat(REPLACE(REPLACE(REPLACE(el_to, 'https://quickstatements.toolforge.org/index_old.html#v1=',''),'%09','|'),'%0A','|'),'S4656|\'"https://commons.wikimedia.org/wiki/Creator',page_title,'"')
SELECT el_to, page_title
FROM externallinks
JOIN page ON page_id = el_from
JOIN categorylinks ON cl_from = page_id
WHERE 
    page_namespace = 100 
	AND cl_to='Creator_templates_with_Wikidata_link:_quick_statements'  
    #AND el_to LIKE 'https://quickstatements.toolforge.org/index_old.html%'
limit 10000

SQL

Checking query status...