nlwiki Disambiguation pages with missing wikilinks

SQL

SELECT dp_ns, dp_title, rp.page_namespace AS rp_ns, rp.page_title AS rp_title
FROM (
	SELECT page_id AS dp_id, page_namespace AS dp_ns, page_title AS dp_title, REGEXP_REPLACE(page_title, '_\\(.*\\)', '') AS dp_label
	FROM page, page_props
  	WHERE pp_page=page_id AND pp_propname='disambiguation') dp, page rp
WHERE
	dp_ns=rp.page_namespace AND
    dp_title!=rp.page_title AND
    dp_label=REGEXP_REPLACE(rp.page_title, '_\\(.*\\)', '') AND
    NOT EXISTS (SELECT * FROM pagelinks WHERE pl_from=dp_id AND pl_namespace=rp_ns AND pl_title=rp_title)
LIMIT 10
    
/*
SELECT page_namespace AS dp_ns, page_title AS dp_title
FROM page, pagelinks
WHERE
	page_id=pl_from AND
    NOT (pl_namespace=4 AND pl_title='Doorverwijspagina') AND
	EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation')
GROUP BY pl_from*/
SQL

Checking query status...
