Pibot candidates for Infobox (current)

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

1075 rows on 2024-08-24

SQL

SELECT DISTINCT pp.pp_value, p1.page_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 page_props AS pp 
ON pp.pp_page = p1.page_id 
AND pp.pp_propname = 'wikibase_item'

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 = 'Category_redirects'  AND cl_type = 'subcat'
  		AND cl1.cl_from = p1.page_id
		LIMIT 1
	) IS NULL

SQL

Checking query status...