Candidates to be linked from disambiguations on cswiki (existing)

SQL

USE cswiki_p;
SELECT disambigs.page_title, links.title
FROM page_props
JOIN page AS disambigs ON disambigs.page_id = pp_page
JOIN (
  (
    SELECT page_title AS title FROM page AS allpages WHERE allpages.page_namespace = 0
    UNION
    SELECT pl_title AS title FROM pagelinks AS alllinks WHERE alllinks.pl_namespace = 0
  )
) AS links
WHERE pp_propname = 'disambiguation'
AND links.title LIKE CONCAT(SUBSTRING_INDEX(disambigs.page_title, '_(', 1), '\\_%')
AND NOT EXISTS (
  SELECT 1 FROM pagelinks WHERE pl_from = pp_page AND pl_title = links.title
);

SQL

Checking query status...