use commonswiki_p;

SELECT iwl_title, 'P1612', CONCAT("\"", REPLACE(page_title, "_", " "), "\"") FROM categorylinks

JOIN page ON cl_from=page_id AND page_namespace=106 AND page_is_redirect=0

JOIN iwlinks ON cl_from=iwl_from AND page_id=cl_from AND iwl_prefix='wikidata' AND iwl_title LIKE 'Q%'

WHERE cl_to='Institution_templates_with_Wikidata_link:_item_missing_linkback' AND

cl_type='page'

LIMIT 1000;