Candidates to be linked from disambiguations on cswiki (redlinks)

SQL

USE cswiki_p;
SELECT page_title, page_id, sub.pl_title
FROM (
  SELECT DISTINCT SUBSTRING_INDEX(pl_title, '_(', 1) AS title, pl_title, pl_namespace
  FROM pagelinks WHERE pl_title LIKE '%&_(%)' ESCAPE '&' AND pl_namespace = 0
) AS sub
JOIN page ON page_title = title AND page_namespace = pl_namespace
JOIN page_props ON pp_page = page_id
LEFT JOIN pagelinks AS dlinks ON dlinks.pl_from = page_id AND dlinks.pl_namespace = sub.pl_namespace AND dlinks.pl_title = sub.pl_title
WHERE pp_propname = 'disambiguation'
/*AND NOT EXISTS (
  SELECT 1 FROM pagelinks AS dlinks
  WHERE dlinks.pl_from = page_id
  AND dlinks.pl_namespace = sub.pl_namespace
  AND dlinks.pl_title = sub.pl_title
)*/ LIMIT 1;
#ORDER BY page_title;

SQL

Checking query status...