Pibot candidates for Infobox (new)

list of categories with items at Commons, but no infobox:
* excludes "Category redirects"
* some have the sandbox infobox
* includes categories without any parent categories

1167 rows on 2024-08-24, 92 additional rows

SQL

SELECT DISTINCT pp.pp_value, p1.page_title
FROM page as p1
JOIN page_props AS pp 
ON pp.pp_page = p1.page_id 
AND pp.pp_propname = 'wikibase_item'
AND p1.page_namespace=14 
AND p1.page_is_redirect=0
LEFT JOIN templatelinks AS tl 
ON tl.tl_from = p1.page_id 
AND tl.tl_from_namespace = 14 
AND tl_target_id = (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = 'Wikidata_Infobox')
WHERE tl.tl_target_id IS NULL
AND (
		SELECT cl1.cl_from
		FROM categorylinks AS cl1 WHERE cl1.cl_to = page_title AND cl2.cl_to = 'Category_redirects'  AND cl_type = 'subcat'
		LIMIT 1
	) IS NULL

SQL

Checking query status...