Candidates to be linked from disambiguations on cswiki (redlinks)

SQL

USE cswiki_p;
SELECT disambigs.page_title AS d, alllinks.page_title AS t
FROM page_props
JOIN page AS disambigs ON disambigs.page_id = pp_page
JOIN pagelinks AS alllinks
LEFT JOIN page AS missing ON missing.page_title = alllinks.pl_title AND missing.page_namespace = alllinks.pl_namespace
WHERE pp_propname = 'disambiguation'
AND alllinks.pl_namespace = 0
AND alllinks.pl_title LIKE CONCAT(REPLACE(SUBSTRING_INDEX(disambigs.page_title, '_(', 1), '_', '&_'), '&_(%') ESCAPE '&'
AND alllinks.page_title NOT IN (SELECT pl_title FROM pagelinks WHERE pl_from = pp_page AND pl_namespace = 0)
AND missing.page_id IS NULL
LIMIT 10;

SQL

Checking query status...