mp7.5.5 articles with films' links to be corrected

SQL

USE fawiki_p;
SELECT REPLACE(pg.page_title,'_',' ') page_title, REPLACE(rd.page_title,'_',' ') old_link, REPLACE(rd_title,'_',' ') new_link
#SELECT REPLACE(pg.page_title,'_',' ') page_title, REPLACE(rd.page_title,'_',' ') old_link, REPLACE(rd_title,'_',' ') new_link, COUNT(rd.page_title)
FROM page AS rd JOIN redirect ON rd_from = rd.page_id JOIN pagelinks ON pl_title = rd.page_title JOIN page AS pg ON pl_from = pg.page_id
WHERE rd.page_namespace = 0
AND rd.page_is_redirect = 1 
AND rd.page_title LIKE "%(فیلم)"
AND rd_namespace = 0
AND rd_title LIKE "%(فیلم\_%"
AND MID(rd_title,1,LOCATE('(فیلم',rd_title)-2) = MID(rd.page_title,1,LOCATE('(فیلم',rd.page_title)-2)
AND pl_from_namespace = 6 # <<<<<<<<------------ Namespace of the page containing the link
AND pl_namespace = 0
#AND pg.page_namespace = 6 
AND pg.page_is_redirect = 0
/*
GROUP BY rd.page_title
ORDER BY COUNT(rd.page_title) DESC;
*/
SQL

Checking query status...
