Cities lacking links to similarly named townships

SQL

SELECT REPLACE(cl_to, "Townships_in_", "") AS State, Pc.page_title AS City, Pt.page_title AS Township
FROM categorylinks
JOIN page Pt ON Pt.page_id = cl_from AND Pt.page_namespace = 0 AND Pt.page_is_redirect = 0
JOIN page Pc ON Pc.page_namespace = 0 AND Pc.page_title = REGEXP_REPLACE(Pt.page_title, "_Township(,.*County)?", "")
 AND Pc.page_is_redirect = 0 AND Pc.page_id != Pt.page_id
WHERE cl_to LIKE "Townships_in_%" AND cl_to NOT LIKE "Townships_in_%_County%" AND cl_type = 'page'
AND NOT EXISTS (SELECT 1 FROM pagelinks WHERE pl_from = Pt.page_id AND pl_namespace = 0 AND pl_title = Pc.page_title)
ORDER BY State, City, Township

SQL

Checking query status...