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;

SQL

Checking query status...