Taxonomy templates linking to non-taxon homonyms

SQL

SET STATEMENT max_statement_time=1000 FOR
SELECT Pt.page_title
FROM page Pt /* Template:Foo */
JOIN pagelinks ON pl_from = Pt.page_id AND pl_title = Pt.page_title AND pl_namespace = 0 /* Template:Foo has a wikilink to [[Foo]] */
JOIN page Pa ON Pa.page_title = Pt.page_title AND Pa.page_namespace = 0 /* article Foo */
WHERE Pt.page_namespace=10 AND Pt.page_title like 'Taxonomy/G%'
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
)
LIMIT 100;

SQL

Checking query status...