tpmp9 page redirects, talk exists

https://fa.wikipedia.org/w/index.php?title=%D9%88%DB%8C%DA%A9%DB%8C%E2%80%8C%D9%BE%D8%AF%DB%8C%D8%A7:%D8%AF%D8%B1%D8%AE%D9%88%D8%A7%D8%B3%D8%AA%E2%80%8C%D9%87%D8%A7%DB%8C_%D8%B1%D8%A8%D8%A7%D8%AA&oldid=18083383#.D8.A8.D8.B1.D9.88.D8.B2.D8.B1.D8.B3.D8.A7.D9.86.DB.8C_.D8.AE.D9.88.D8.AF.DA.A9.D8.A7.D8.B1_.D8.B5.D9.81.D8.AD.D9.87.E2.80.8C.D9.87.D8.A7.DB.8C_.D8.A8.D8.AD.D8.AB

2621
2653
3063
3016
2972
3192
12588
3928
1446
1482

SQL

USE fawiki_p;
SELECT t.page_title, t.page_len, t.page_id
FROM page AS t
WHERE t.page_namespace  = 1
AND t.page_is_redirect = 0
AND t.page_len > 0
AND EXISTS (
  SELECT null
  FROM page AS p
  WHERE p.page_namespace = 0
  AND p.page_title = t.page_title
  AND p.page_is_redirect = 1
)
AND t.page_title NOT IN (
  SELECT pl_title
  FROM pagelinks JOIN categorylinks ON cl_from = pl_from
  WHERE pl_from_namespace = 1
  AND pl_namespace = 1
  AND cl_to = 'صفحه‌های_دارای_جعبه_بحث‌شده_در_جای_دیگر'
  AND pl_title = t.page_title
)

AND t.page_id IN (
  SELECT page_id
  FROM page JOIN templatelinks ON page_id = tl_from
  WHERE tl_from_namespace = 1
  AND tl_title = 'پیشینه_حذف'
#  AND page_len < 500
  )
ORDER BY t.page_len DESC;

SQL

Checking query status...