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

SQL

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

SQL

Checking query status...