Disambiguations to be merged (cswiki)

SQL

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 page_title
FROM page AS second
WHERE second.page_title LIKE '%\_(%)'
AND second.page_title NOT LIKE '%)%)'
AND second.page_namespace = 0 
AND second.page_is_redirect = 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)
)
AND second.page_title NOT LIKE 'Seznam\_kulturních\_památek%';
#*/
SQL

Checking query status...
