Commons sub-sub-cats with Wikidata sitelinks but no WD infobox

Fork of Commons sub-cats with Wikidata sitelinks but no WD infobox by Jheald

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

SQL

use commonswiki_p;
SELECT pp.pp_value, p2.page_title, tl.tl_namespace, tl.tl_title
FROM categorylinks AS c1
JOIN page AS p1 ON c1.cl_from=p1.page_id AND p1.page_namespace=14 AND p1.page_is_redirect=0
JOIN categorylinks AS c2 ON c2.cl_to = p1.page_title
JOIN page AS p2 ON c2.cl_from=p2.page_id AND p2.page_namespace=14 AND p2.page_is_redirect=0
JOIN page_props AS pp ON pp.pp_page = c2.cl_from AND pp.pp_propname = 'wikibase_item'
LEFT JOIN templatelinks AS tl ON tl.tl_from = c1.cl_from AND tl.tl_from_namespace = 14 AND tl.tl_namespace = 10 AND tl.tl_title = 'Wikidata_Infobox' 

WHERE c1.cl_to='Grade_I_listed_buildings_in_Wales'
AND tl.tl_title IS NULL
# GROUP BY p2.page_title;
# LIMIT 500;

SQL

Checking query status...