Commons:All categories with Wikidata link that aren't using Wikidata Infobox or Taxonavigation

SQL

use commonswiki_p;
SELECT DISTINCT pp.pp_value, p1.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 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.tl_namespace = 10 AND tl.tl_title = 'Wikidata_Infobox' 
LEFT JOIN templatelinks AS t2 ON t2.tl_from = p1.page_id AND t2.tl_from_namespace = 14 AND t2.tl_namespace = 10 AND t2.tl_title = 'Taxonavigation' 

WHERE tl.tl_title IS NULL and t2.tl_title IS NULL

SQL

Checking query status...