vcmp4.1 villages having "Infobox_settlement"

SQL

USE fawiki_p;
SELECT REPLACE(page_title,'_',' '), cl_to
FROM page JOIN categorylinks ON cl_from = page_id
WHERE page_namespace = 0
AND cl_to LIKE '%روستاهای_شهرستان%'

AND page_id IN (
  SELECT tl_from
  FROM templatelinks
  WHERE tl_title LIKE 'Infobox_settlement'
  )

AND page_id NOT IN (
  SELECT cl_from
  FROM categorylinks
  WHERE cl_to LIKE '%آمریکا%'
  AND cl_to LIKE '%لهستان%'
  AND cl_to LIKE '%مقاله‌های_خرد_هند%'
  AND cl_to LIKE '%تگزاس%'
  )

ORDER BY cl_to;

SQL

Checking query status...