Candidates to be linked from disambiguations on cswiki (redlinks)

SQL

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

Checking query status...
