Capture QuickStatement external links of {{Institution}} templates

SQL

use commonswiki_p;
SELECT REPLACE(REPLACE(REPLACE(el_to, 'https://quickstatements.toolforge.org/#/v1=',''), '%7C','|'),'||','#')
FROM externallinks
JOIN page ON page_id = el_from
JOIN categorylinks ON cl_from = page_id
WHERE 
    page_namespace in (6,14) and #14
	cl_to='Institution_templates_with_Wikidata_link:_item_missing_linkback' AND 
    el_to LIKE 'https://quickstatements.toolforge.org%'
limit 30000

​x
 
use commonswiki_p;SELECT REPLACE(REPLACE(REPLACE(el_to, 'https://quickstatements.toolforge.org/#/v1=',''), '%7C','|'),'||','#')FROM externallinksJOIN page ON page_id = el_fromJOIN categorylinks ON cl_from = page_idWHERE     page_namespace in (6,14) and #14    cl_to='Institution_templates_with_Wikidata_link:_item_missing_linkback' AND     el_to LIKE 'https://quickstatements.toolforge.org%'limit 30000​

SQL

Checking query status...