# of villages containing bracket in the title (template based)

SQL

USE fawiki_p;
SELECT DISTINCT REPLACE(frst.page_title,'_',' '),MID(frst.page_title,1,LOCATE('(',frst.page_title)-2)#,cl_to,MID(page_title,1,LOCATE('(',page_title)-2),MID(cl_to,LOCATE('شهرستان',cl_to)+15,LENGTH(cl_to))
FROM page AS frst JOIN categorylinks ON cl_from = frst.page_id
WHERE frst.page_namespace=0
AND page_title LIKE "%)%"
AND cl_to LIKE 'روستاهای_شهرستان%'
AND NOT EXISTS (
  SELECT null
  FROM page AS scnd JOIN categorylinks ON cl_from = scnd.page_id
  WHERE scnd.page_namespace=0
  AND cl_to LIKE 'روستاهای_شهرستان%'
  AND frst.page_title <> scnd.page_title
  AND (MID(frst.page_title,1,LOCATE('(',frst.page_title)-2) = MID(scnd.page_title,1,LOCATE('(',scnd.page_title)-2)
       OR MID(frst.page_title,1,LOCATE('(',frst.page_title)-2) = scnd.page_title
       )
)
#AND MID(page_title,1,LOCATE('(',page_title)-2) = MID(cl_to,LOCATE('شهرستان',cl_to)+15,LENGTH(cl_to))
ORDER BY page_title;
SQL

Checking query status...
