SQL
AخA
use commonswiki_p;
SELECT iwl_title, 'P1472', CONCAT("\"", REPLACE(page_title, "_", " "), "\"") FROM categorylinks
JOIN page ON cl_from=page_id AND page_namespace=100 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='Creator_templates_with_Wikidata_link:_item_missing_linkback' AND
cl_type='page'
LIMIT 500;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.