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, t1.tl_title, t2.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 AND p1.page_title = 'Dogs'
LEFT JOIN page_props AS pp ON pp.pp_page = p1.page_id AND pp.pp_propname = 'wikibase_item'
LEFT JOIN templatelinks AS t1 ON t1.tl_from = p1.page_id AND t1.tl_from_namespace = 14 AND t1.tl_namespace = 10 AND t1.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'

SQL

Checking query status...