Taxonomy templates linking to non-taxon homonyms

SQL

SET STATEMENT max_statement_time=1000 FOR
SELECT Pa.page_title
FROM page Pt /* Template:Foo */
JOIN pagelinks ON pl_from = Pt.page_id AND pl_title = SUBSTRING(Pt.page_title,10) AND pl_namespace = 0 /* Template:Taxonomy/Foo has a wikilink to [[Foo]] */
JOIN page Pa ON Pa.page_title = pl_title AND Pa.page_namespace = 0 /* article Foo */
WHERE Pt.page_namespace=10 AND Pt.page_title like 'Taxonomy/A%'
AND NOT EXISTS (
  SELECT 1
  FROM templatelinks
  WHERE tl_from = Pa.page_id
  AND tl_title IN ("Automatic_taxobox","Hybrid","Ichnobox","Infraspeciesbox","Oobox","Speciesbox","Subspeciesbox","Taxobox","Virusbox")
  AND tl_namespace = 10
)
AND NOT EXISTS (
  SELECT 1
  FROM redirect
  JOIN page Pr ON Pr.page_title = rd_title AND Pr.page_namespace = 0
  JOIN templatelinks ON tl_from = Pr.page_id
  AND tl_title IN ("Automatic_taxobox","Hybrid","Ichnobox","Infraspeciesbox","Oobox","Speciesbox","Subspeciesbox","Taxobox","Virusbox")
  AND tl_namespace = 10
  WHERE rd_from = Pa.page_id
)
AND NOT EXISTS (
  SELECT 1
  FROM categorylinks
  WHERE cl_from = Pa.page_id
  AND (cl_to LIKE "%_genera%" OR cl_to LIKE "%_species%")
)
AND NOT EXISTS (
  SELECT 1
  FROM redirect
  JOIN page Pr ON Pr.page_title = rd_title AND Pr.page_namespace = 0
  JOIN categorylinks ON cl_from = Pr.page_id
  AND (cl_to LIKE "%_genera%" OR cl_to LIKE "%_species%")
  WHERE rd_from = Pa.page_id
)
ORDER BY Pa.page_title
LIMIT 100;
SQL

Checking query status...
