Untitled query #30616

SQL

USE fawiki_p;
SELECT REPLACE(rd.page_title,'_',' '), REPLACE(rd_title,'_',' '), DAB.page_title
FROM page AS rd JOIN redirect ON rd_from = rd.page_id JOIN page AS DAB
WHERE rd.page_namespace = 0
AND rd.page_is_redirect = 1 
AND rd.page_title LIKE "%(فیلم)"
AND rd_namespace = 0
AND MID(rd_title,1,LOCATE('(فیلم',rd_title)-2) = MID(rd.page_title,1,LOCATE('(فیلم',rd.page_title)-2)
#AND (rd_title LIKE "%۱%" OR rd_title LIKE "%۲%")
AND (
  MID(rd.page_title,1,LOCATE('(فیلم',rd.page_title)-2) = DAB.page_title
  OR concat(MID(rd.page_title,1,LOCATE('(فیلم',rd.page_title)-2),'_(ابهام‌زدایی)') = DAB.page_title
)
AND DAB.page_namespace = 0
AND DAB.page_is_redirect = 0
AND DAB.page_id IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
)
SQL

Checking query status...
