mp7.5.3 films to be moved and the corresponding target titles

SQL

USE fawiki_p;
SELECT DISTINCT REPLACE(noyr.page_title,'_',' '), concat(MID(noyr.page_title,1,length(noyr.page_title)-1),'_',MID(cl_to,19,8),')') #, REPLACE(yr.page_title,'_',' ')
FROM page AS yr JOIN page AS noyr ON MID(noyr.page_title,1,LOCATE('فیلم',noyr.page_title)-3) = MID(yr.page_title,1,LOCATE('فیلم',yr.page_title)-3) JOIN categorylinks ON cl_from = noyr.page_ID
WHERE noyr.page_namespace = 0
AND noyr.page_is_redirect = 0
AND noyr.page_title LIKE "%(فیلم)"
AND yr.page_namespace = 0
AND yr.page_is_redirect = 0
AND yr.page_title LIKE "%(فیلم%"
AND yr.page_title <> noyr.page_title
AND (
  (cl_to LIKE "فیلم‌های%(میلادی)"
   AND length(cl_to) = 41)
  OR
  (cl_to LIKE "فیلم‌های%۱%"
   AND length(cl_to) = 26)
)
#AND noyr.page_title = "آدم_و_حوا_(فیلم)"
ORDER BY noyr.page_title
LIMIT 5;
SQL

Checking query status...
