vcmp1.2 articles having both city and village category

SQL

USE fawiki_p;
SELECT DISTINCT REPLACE(frst.page_title,'_',' ')
FROM page AS frst
WHERE frst.page_title LIKE '%(فیلم)'
#AND frst.page_title LIKE '%سیاه_و%'
AND frst.page_namespace=0
AND frst.page_is_redirect=0
AND EXISTS (
  SELECT page_title
  FROM page AS scnd
  WHERE MID(frst.page_title,1,LOCATE('(',frst.page_title)-2)=MID(scnd.page_title,1,LOCATE('(',scnd.page_title)-2)
  AND scnd.page_title NOT LIKE '%(فیلم)'
  AND (scnd.page_title LIKE '%(فیلم_%۱)'
       OR scnd.page_title LIKE '%(فیلم_%۲)')
  AND scnd.page_namespace=0
);

SQL

Checking query status...