vcmp vilages/cities with the same name as their county

SQL

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


LIMIT 5;

SQL

Checking query status...