Unnecessary disambiguation

SQL

select * 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 rd_from in (select cl_from from categorylinks where cl_to = 'Redirects_to_disambiguation_pages')
-- 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...
