Taxonomy templates linking to qualified redirects to taxa

Fork of Taxonomy templates linking to non-taxon homonyms by Certes

This query is marked as a draft This query has been published by Certes.

SQL

SELECT Pt.page_title as Template, Pa.page_title AS Article
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 AND pl_title LIKE "%_(%"
JOIN page Pa ON Pa.page_title = pl_title AND Pa.page_namespace = 0 AND Pa.page_is_redirect = 1
JOIN redirect ON rd_from = Pa.page_id AND rd_title = SUBSTRING_INDEX(Pa.page_title, '_(', 1)
JOIN page Pr ON Pr.page_title = rd_title AND Pr.page_namespace = 0
WHERE Pt.page_namespace=10 AND Pt.page_title like 'Taxonomy/%'
ORDER BY Pt.page_title, Pa.page_title

SQL

Checking query status...