Unsynchronized talk page redirects

SQL

with page_redirect as (
  select page_namespace, page_title, rd_title from page
  join redirect on page_id = rd_from and rd_namespace = page_namespace
  where page_is_redirect = 1
)

select pr1.page_title, pr1.rd_title, pr2.rd_title, pr3.rd_title from page_redirect pr1
join page_redirect pr2 on pr1.page_title = pr2.page_title and pr2.page_namespace = 0
join page_redirect pr3 on pr3.page_title = pr1.rd_title and pr3.page_namespace = 0
where pr1.page_namespace = 1 and pr1.rd_title != pr2.rd_title and pr3.rd_title != pr2.rd_title

/*
select pr1.page_title, pr1.rd_title, pr2.rd_title from page_redirect pr1
join page_redirect pr2 on pr1.page_title = pr2.page_title and pr2.page_namespace = 0
left join page p1 on p1.page_title = pr1.rd_title and p1.page_namespace = 0
where pr1.page_namespace = 1 and pr1.rd_title != pr2.rd_title and p1.page_id is null
*/

/*
select pr1.page_title, pr1.rd_title, pr2.rd_title from page_redirect pr1
join page_redirect pr2 on pr1.page_title = pr2.page_title and pr2.page_namespace = 0
join page p1 on p1.page_title = pr1.rd_title and p1.page_namespace = 0 and p1.page_is_redirect = 0
where pr1.page_namespace = 1 and pr1.rd_title != pr2.rd_title
limit 100
*/

/*
select pr1.page_title, pr1.rd_title, pr2.rd_title, r1.rd_namespace, r1.rd_title from page_redirect pr1
join page_redirect pr2 on pr1.page_title = pr2.page_title and pr2.page_namespace = 0
join page p1 on p1.page_title = pr1.rd_title and p1.page_namespace = 0 and p1.page_is_redirect = 1
join redirect r1 on p1.page_id = r1.rd_from and r1.rd_namespace != p1.page_namespace
where pr1.page_namespace = 1 and pr1.rd_title != pr2.rd_title
*/

/*
select pr1.page_title, pr1.rd_title, pr2.rd_title from page_redirect pr1
join page_redirect pr2 on pr1.page_title = pr2.page_title and pr2.page_namespace = 0
join page_redirect pr3 on pr3.page_title = pr1.rd_title and pr3.page_namespace = 0
where pr1.page_namespace = 1 and pr1.rd_title != pr2.rd_title and pr3.rd_title = pr2.rd_title
limit 100
*/
SQL

Checking query status...
