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 COUNT(*) FROM (SELECT SUBSTRING_INDEX(pl_title, '_(', 1) AS title, pl_namespace FROM pagelinks WHERE pl_title LIKE '%)') AS sub;

SQL

Checking query status...