Primary redirect of sort names

SQL

select substring(page_title, 1, INSTR(page_title, "_(disambiguation)")-1) as from_title, page_title, rd_title
from page join redirect on page_id = rd_from and rd_from_namespace = 0
where page_namespace = 0 and page_title like '%,\_The\_(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...
