Vilage titles disambiguated with things other than county name

SQL

USE fawiki_p;
#SELECT page_title,MID(page_title,LOCATE('(',page_title)+1,length(page_title)-16),MID(page_title,LOCATE('(',page_title)+1,LOCATE(')',page_title)-16)
SELECT page_title,REPLACE(CONCAT('شهرستان_',REPLACE(MID(page_title,LOCATE('(',page_title)+1,length(page_title)),')','')),'_',' ')
FROM page
WHERE page_namespace = 0
AND page_is_redirect=0
AND page_title LIKE "%(%"
AND page_id IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to LIKE "روستاهای_%"
)
AND  EXISTS (
  SELECT null
  FROM page
  WHERE page_namespace = 0
  AND page_is_redirect=0
  AND page_title = REPLACE(CONCAT('شهرستان_',REPLACE(MID(page_title,LOCATE('(',page_title)+1,length(page_title)),')','')),'_',' ')
  )
ORDER BY page_title
LIMIT 100;

SQL

Checking query status...