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, rd_title, p2.page_title) as to_title from page p1
join page p2 on p2.page_namespace = 0
and p2.page_title = concat('The_', substring(p1.page_title, 1, INSTR(p1.page_title, ",_The_(disambiguation)")-1))
left join redirect on p2.page_id = rd_from and rd_namespace = 0
where p1.page_namespace = 0 and p1.page_is_redirect = 1
and p1.page_title like '%,\_The\_(disambiguation)'
order by from_title
/*
and substring(p1.page_title, 1, INSTR(p1.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...
