Non-trivial redirects

SQL

USE fawiki_p;
SELECT REPLACE(concat('* [[',page_title,']]'),'_',' '), REPLACE(concat('[[',rd_title,']]'),'_',' '), MID(page_title,1,LOCATE('(ابهام',page_title)-2)
FROM page JOIN redirect ON page_id = rd_from
WHERE page_is_redirect = 1
AND page_namespace = 0
AND rd_namespace = 0
#GROUP BY rd_title
#ORDER BY page_title
AND NOT LOWER(CONVERT(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(MID(page_title,1,LOCATE('(ابهام',page_title)-2),'آ','ا'),'هٔ','ه'),'ك','ک'),'ي','ی'),'‌',''),'_','') USING utf8mb4)) = LOWER(CONVERT(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(rd_title,'آ','ا'),'هٔ','ه'),'ك','ک'),'ي','ی'),'‌',''),'_','') USING utf8mb4))

#AND NOT LOWER(CONVERT(page_title USING utf8mb4)) = LOWER(CONVERT(rd_title USING utf8mb4))

#REPLACE(concat(', [[',MID(page_title,1,LOCATE('(',page_title)-2),']]'),'_',' ')

AND rd_title LIKE 'ACH'
LIMIT 1000;
SQL

Checking query status...
