Primary redirect of sort names

SQL

select substring(p1.page_title, 1, INSTR(p1.page_title, "_(disambiguation)")-1) as from_title,
if(p2.page_is_redirect = 1, r2.rd_title, p2.page_title) as to_title, p2.page_title, r2.rd_title
from page p1 join redirect r1 on p1.page_id = r1.rd_from and r1.rd_namespace = 0
join page p2 on p2.page_title = substring(r1.rd_title, 1, INSTR(r1.rd_title, "_(disambiguation)")-1) and p2.page_namespace = 0
left join redirect r2 on p2.page_id = r2.rd_from and r2.rd_namespace = 0
where p1.page_namespace = 0 and p1.page_is_redirect = 1
and p1.page_title like '%,\_The\_(disambiguation)' and r1.rd_title like '%\_(disambiguation)'
/*
and substring(page_title, 1, INSTR(page_title, "_(disambiguation)")-1) not in (
  select page_title from page where page_namespace = 0
)
*/
/*
select page_title from page
where page_title not like '%\_(disambiguation)' and page_namespace = 0
and page_id in (
  select cl_from from categorylinks
  where cl_type = 'page' and cl_to in ('Redirects_to_disambiguation_pages')
)
*/
SQL

Checking query status...
