Candidates to be linked from disambiguations on cswiki (redlinks)

SQL

USE cswiki_p;
/*
SELECT DISTINCT disambigs.page_title, alllinks.pl_title
FROM page_props
JOIN page AS disambigs ON disambigs.page_id = pp_page
JOIN pagelinks AS alllinks
WHERE pp_propname = 'disambiguation'
AND alllinks.pl_from_namespace = 0
AND alllinks.pl_namespace = 0
AND alllinks.pl_title LIKE CONCAT(REPLACE(SUBSTRING_INDEX(disambigs.page_title, '_(', 1), '_', '#_'), '#_(%)') ESCAPE '#'
AND alllinks.pl_title NOT IN (SELECT pl_title FROM pagelinks WHERE pl_from = pp_page AND pl_namespace = 0)
AND NOT EXISTS (
  SELECT 1 FROM page AS missing WHERE missing.page_title = alllinks.pl_title AND missing.page_namespace = alllinks.pl_namespace
)
LIMIT 100;
/*/
SELECT DISTINCT disambigs.page_title, alllinks.pl_title
FROM pagelinks AS alllinks
JOIN page AS disambigs
JOIN page_props ON pp_page = disambigs.page_id
WHERE pp_propname = 'disambiguation'
AND alllinks.pl_from_namespace = 0
AND alllinks.pl_namespace = 0
AND alllinks.pl_title LIKE '%\_(%)'
AND disambigs.page_namespace = 0
AND disambigs.page_title IN (
  SUBSTRING_INDEX(alllinks.pl_title, '_(', 1), CONCAT(SUBSTRING_INDEX(alllinks.pl_title, '_(', 1), '_(rozcestník)')
) AND alllinks.pl_title NOT IN (SELECT pl_title FROM pagelinks WHERE pl_from = pp_page AND pl_namespace = 0)
AND NOT EXISTS (
  SELECT 1 FROM page AS missing WHERE missing.page_title = alllinks.pl_title AND missing.page_namespace = alllinks.pl_namespace
)
LIMIT 10;
#*/
SQL

Checking query status...
