vcmp vilages/cities with the same name as their county

SQL

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

SQL

Checking query status...