Unnecessary disambiguation

SQL

select * from redirect
join page sp on rd_from = page_id 
where (page_title like CONCAT(rd_title, ',_%') or page_title like CONCAT(rd_title, '_%'))
and rd_namespace = page_namespace
-- select sp.page_namespace, sp.page_title, tp.page_namespace, tp.page_title, rd_fragment from redirect
-- join page sp on rd_from = sp.page_id
-- join page tp on rd_title = tp.page_title and rd_namespace = tp.page_namespace
-- where sp.page_id in (select cl_from from categorylinks where cl_to = 'Redirects_to_disambiguation_pages')
-- and tp.page_id not in (select cl_from from categorylinks where cl_to IN ('All_disambiguation_pages', 'All_set_index_articles'))
-- and rd_fragment != ''
-- and rd_title not like '%_(disambiguation)'
-- and rd_namespace != page_namespace
-- and page_is_redirect = 1
-- and page_title like '%_(disambiguation)'
-- and substring(page_title, 1, INSTR(page_title, "_(disambiguation)")-1) not in (select page_title from page)
limit 100
SQL

Checking query status...
