Redirects pointing at other redirects

SQL

SELECT P_from.page_title AS title_from, P_to.page_title AS title_to, P_next.page_title AS title_next, 
   P_from.page_namespace AS ns_from, P_to.page_namespace AS ns_to, P_next.page_namespace AS ns_next, 
   R_a.rd_interwiki AS iw_to, R_a.rd_fragment AS section_to, 
   R_b.rd_interwiki AS iw_next, R_b.rd_fragment AS section_next
FROM ukwiki_p.redirect R_a
JOIN ukwiki_p.page P_from ON R_a.rd_from=P_from.page_id
JOIN ukwiki_p.page P_to ON R_a.rd_namespace=P_to.page_namespace AND R_a.rd_title=P_to.page_title
JOIN ukwiki_p.redirect R_b ON P_to.page_id=R_b.rd_from
JOIN ukwiki_p.page P_next ON R_b.rd_namespace=P_next.page_namespace AND R_b.rd_title=P_next.page_title
WHERE P_to.page_is_redirect=1
LIMIT 1000
SQL

Checking query status...
