mp7.5.5 articles with films' links to be corrected

SQL

USE fawiki_p;
SELECT REPLACE(pg.page_title,'_',' ') article, REPLACE(rd.page_title,'_',' ') link_to_be_replaced, REPLACE(rd_title,'_',' ') replacement
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)-1) = MID(rd.page_title,1,LOCATE('(فیلم',rd.page_title)-1)
AND pl_from_namespace = 0 
AND pl_namespace = 0
AND pg.page_namespace = 0
AND pg.page_is_redirect = 0

SQL

Checking query status...