Candidates to be linked from disambiguations on cswiki (redlinks)

SQL

USE cswiki_p;
SELECT disambig.page_title, sub.pl_title, IF(target.page_title IS NULL, 0, 1) AS page_exists
	#, IF(target.page_is_redirect = 1, 1, 0) AS page_is_redirect
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 AND pl_from_namespace = 0
) AS sub
JOIN page AS disambig ON disambig.page_title = sub.title AND disambig.page_namespace = sub.pl_namespace
JOIN page_props ON pp_page = disambig.page_id
LEFT JOIN page AS target ON target.page_title = sub.pl_title AND target.page_namespace = sub.pl_namespace
LEFT JOIN pagelinks AS dlinks
	ON dlinks.pl_from = disambig.page_id AND dlinks.pl_namespace = sub.pl_namespace AND dlinks.pl_title = sub.pl_title
WHERE pp_propname = 'disambiguation' AND dlinks.pl_from IS NULL
AND (target.page_title IS NULL OR (target.page_is_redirect = 0 AND NOT EXISTS (
  SELECT 1 FROM pagelinks AS rlinks
  JOIN page AS r ON r.page_title = rlinks.pl_title AND r.page_namespace = rlinks.pl_namespace
  JOIN redirect ON rd_from = r.page_id
  WHERE rd_title = target.page_title AND rd_namespace = target.page_namespace
)))
ORDER BY disambig.page_namespace, disambig.page_title, sub.pl_namespace, sub.pl_title;
SQL

Checking query status...
