red links caused by moving pages without leaving a rediredt behind

SQL

USE fawiki_p;
SELECT DISTINCT concat('# ',MID(rev_comment,locate('صفحهٔ [[',rev_comment)+11,locate(']] را بدون',rev_comment)-locate('صفحهٔ [[',rev_comment)-9))
FROM revision
WHERE rev_comment LIKE '%را_بدون_برجای‌گذاشتن_تغییرمسیر_به%'
AND rev_comment NOT LIKE '%کاربر:%'
#AND pl_namespace = 0
AND MID(rev_comment,locate('صفحهٔ [[',rev_comment)+13,locate(']] را بدون',rev_comment)-locate('صفحهٔ [[',rev_comment)-13) NOT IN (
  SELECT REPLACE(page_title,'_',' ')
  FROM page
  WHERE page_namespace=0
  )
#  AND rev_timestamp >20160625000000
#  AND rev_user_text='MammothBot' #rev_user=user_id
LIMIT 10;

SQL

Checking query status...