Village pages in tewp

SQL

use tewiki_p;
SELECT  DISTINCT(page_title)
FROM page
LEFT JOIN  (SELECT * from categorylinks) cl1 ON cl1.cl_from = page.page_id
WHERE page.page_namespace = 0 AND page_is_redirect =0 AND cl1.cl_to LIKE '%_జిల్లా_గ్రామాలు' and page_title NOT IN
	(SELECT  DISTINCT(page_title)
     FROM page
     LEFT JOIN  (SELECT * from categorylinks) cl2 ON cl2.cl_from = page.page_id
 	 WHERE page.page_namespace = 0 AND page_is_redirect =0 AND cl2.cl_to  LIKE '%నగరాలు_మరియు_పట్టణాలు'	 )
GROUP BY page_title
ORDER BY page_title
SQL

Checking query status...
