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]+_[a-z]+$' 
GROUP BY redirect
HAVING candidates != target
ORDER BY redirect

AخA
 
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 candidatesFROM page PsJOIN 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=1JOIN redirect ON rd_from=Pa.page_idWHERE Ps.page_namespace=0 AND Ps.page_title LIKE "Q%" AND CONVERT(Ps.page_title USING BINARY) REGEXP '^[A-Z][a-z]+_[a-z]+$' GROUP BY redirectHAVING candidates != targetORDER BY redirect

SQL

Checking query status...