Dabs "Foo and bar" matching articles "Foo and Bar"

SQL

SELECT Pd.page_title
FROM categorylinks
JOIN page Pd ON Pd.page_id = cl_from AND Pd.page_title REGEXP "_and_[a-z]" AND Pd.page_namespace = 0
JOIN page Pa ON Pa.page_namespace = 0 AND Pa.page_is_redirect = 0 
AND Pa.page_title = CONCAT(SUBSTRING_INDEX(Pd.page_title, "_and_", 1),"_and_",
 UPPER(CONVERT(SUBSTRING(Pd.page_title, LOCATE("_and_", Pd.page_title)+5, 1) USING latin1)),
 SUBSTRING(Pd.page_title, LOCATE("_and_", Pd.page_title)+6))
WHERE cl_to = "All_disambiguation_pages" AND cl_type = "page"

SQL

Checking query status...