red links caused by moving pages without leaving a rediredt behind (old version)

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 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 INNER JOIN page ON rev_page=page_id
  WHERE rev_comment LIKE concat('%[[',pl_title,']]_را_بدون_برجای‌گذاشتن_تغییرمسیر_به%')
  AND page_namespace = 0
  AND page_is_redirect = 0
#  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...