Disambiguations to be merged

SQL

/*
select p1.page_title, p2.page_title from page p1
join page p2 on p2.page_title = substring(p1.page_title, 1, INSTR(p1.page_title, '_(disambiguation)')-1)
where p1.page_title like '%\_(disambiguation)' and p1.page_namespace = 0 and p1.page_is_redirect = 0
and p2.page_namespace = 0 and p2.page_is_redirect = 0
and p2.page_id in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page')
*/

select page_title, substring(page_title, 1, INSTR(page_title, '_(')-1) from page
where page_id in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page')
and page_namespace = 0 and page_is_redirect = 0
and page_title like '%\_(%)' and page_title not like '%\_(disambiguation)'
SQL

Checking query status...
