Misdirected taxonomy links via redirects

SQL

SELECT Plist.page_title, Predir.page_title, Ptaxo.page_title
FROM page Plist
JOIN pagelinks PL ON PL.pl_from_namespace = 0 AND PL.pl_from = Plist.page_id
JOIN page Predir ON Predir.page_namespace = 0 AND Predir.page_title = PL.pl_title
JOIN redirect R ON R.rd_from = Predir.page_id
JOIN page Ptaxo ON Ptaxo.page_namespace = 0 AND Ptaxo.page_title = R.rd_title
WHERE Plist.page_namespace = 0 AND Plist.page_title BETWEEN "List" AND "Lisu" AND Plist.page_title LIKE "List_of_the_Cenozoic_life_of_%"
AND PL.pl_namespace = 0
AND Predir.page_is_redirect = 1
AND R.rd_namespace = 0
AND Ptaxo.page_is_redirect = 1
AND NOT EXISTS (SELECT 1 FROM pagelinks PLt
                WHERE PLt.pl_from_namespace = 0 AND PLt.pl_from = Ptaxo.page_id AND PLt.pl_namespace = 10
                AND PLt.pl_title = "Taxobox")
ORDER BY Plist.page_title, Predir.page_title, Ptaxo.page_title
SQL

Checking query status...
