Cities lacking links to similarly named townships

SQL

SELECT REPLACE(cl_to, "Townships_in_", "") AS State, Pc.page_title, Pt.page_title
FROM categorylinks
JOIN page Pt ON Pt.page_id = cl_from AND Pt.page_namespace = 0
JOIN page Pc ON Pc.page_namespace = 0 AND Pc.page_title = REGEXP_REPLACE(Pt.page_title, "_Township(,.*County)?", "")
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, Pc.page_title, Pt.page_title

SQL

Checking query status...