Disambiguations to be merged (cswiki)

SQL

USE cswiki_p;
/*
SELECT page_title FROM page_props AS PP
JOIN page AS P ON PP.pp_page = P.page_id
WHERE PP.pp_propname = 'disambiguation' AND EXISTS (
  SELECT 1 FROM page AS other
  WHERE other.page_namespace = P.page_namespace
  AND other.page_title = CONCAT(P.page_title, '_(rozcestník)')
  AND other.page_is_redirect = 0
);
*/
SELECT * FROM page AS second
WHERE second.page_title LIKE '%\_(%)'
AND second.page_title NOT LIKE '%)%)'
AND second.page_namespace = 0 AND NOT EXISTS (
  SELECT 1 FROM page AS prim
  WHERE prim.page_namespace = second.page_namespace
  AND prim.page_title = SUBSTRING_INDEX(second.page_title, '_(', 1)
) LIMIT 10;
SQL

Checking query status...
