USE fawiki_p;

SELECT DISTINCT REPLACE(concat('* [[',noyr.page_title,']] > [[', 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)

)

ORDER BY noyr.page_title;