vcmp vilages/cities with the same name as their county

SQL

USE fawiki_p;
SELECT concat ('# [[',pl_title,']]')
FROM pagelinks
WHERE pl_namespace = 0
#AND pl_title NOT IN (
#  SELECT page_title
#  FROM page
#  WHERE page_namespace = 0)
AND NOT EXISTS (
  SELECT null
  FROM page
  WHERE page_title = pl_title
  AND page_namespace=0)
#AND pl_title = 'ممکنه_دوستم_بشی؟(فیلم_هندی2002)' 
AND EXISTS (
  SELECT null
  FROM revision
  WHERE rev_comment LIKE concat('%[[',pl_title,']]_را_بدون_برجای‌گذاشتن_تغییرمسیر_به%')
#  AND rev_timestamp >20160625000000
#  AND rev_user_text='MammothBot' #rev_user=user_id
  )
#ORDER BY COUNT(pl_title) DESC
LIMIT 5;

SQL

Checking query status...