tpmp1 conjugate pages

«مقاله‌های تغییرمسیری که بحث‌شان مقصدِ تغییرمسیرِ بحثِ مقصدِ تغییرمسیرِ مقالهٔ اول است»
بحث مرتبط: 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=18063900#.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
126
86
8
20
3
31
38
8

SQL

use fawiki_p;
select page_title,page_len,r1.rd_title
from page as p1 join redirect as r1 on rd_from = page_id
where -- talk page is a redirect
page_namespace  = 1
and page_is_redirect = 1
and exists (
  select null
  from page as p1
  -- related article is not a redirect
  where page_namespace = 0
  and page_title = p1.page_title
  and page_is_redirect = 0
)
and exists (
  select null
  from page as p2
  -- target's related article is a redirect
  where p2.page_namespace = 0
  and p2.page_title = r1.rd_title
  and p2.page_is_redirect = 1
  and exists (
    select null
    from redirect
    -- target's related article is a redirect back to the original title
    where rd_from = p2.page_id
    and rd_namespace = 0
    and rd_title = p1.page_title
  )
)
ORDER BY page_len DESC;

SQL

Checking query status...