Untitled query #78922

SQL

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

Checking query status...
