Untitled query #78922

SQL

SELECT Pa.page_title AS redirect, rd_title AS target, GROUP_CONCAT(Ps.page_title, ", ") AS candidates
FROM page Pa
JOIN redirect ON rd_from=page_id
LEFT JOIN page Ps ON Ps.page_namespace=0 AND Ps.page_title LIKE "A._%"
 AND CONVERT(Ps.page_title USING latin1) REGEXP REGEXP_REPLACE(Pa.page_title, '\\.', '[a-z]+', 1)
WHERE Pa.page_namespace=0 AND Pa.page_title LIKE "A._%" AND CONVERT(Pa.page_title USING latin1) REGEXP '^[A-Z]\\._[a-z]+$' AND Pa.page_is_redirect=1
GROUP BY redirect
ORDER BY redirect
SQL

Checking query status...
