nds_nlwiki Links to disambiguation pages

SQL

USE nds_nlwiki_p;
SELECT page_namespace, page_title, COUNT(pl_from)
FROM page, page_props, pagelinks
WHERE
	page_is_redirect=0 AND
    page_id=pp_page AND
    pp_propname='disambiguation' AND
    pl_namespace=page_namespace AND
    pl_title=page_title
LIMIT 50
/*
SELECT 
	pf.page_namespace AS 'from_ns', 
    pf.page_title AS 'from_title', 
    pt.page_namespace AS 'to_ns',
    pt.page_title AS 'to_title',
    rev_timestamp AS 'current'
FROM page pt, page_props, pagelinks, page pf, revision
WHERE 
	pf.page_is_redirect=0 AND
	pt.page_id=pp_page AND
	pp_propname='disambiguation' AND
	pl_namespace=pt.page_namespace AND
	pl_title=pt.page_title AND
	pt.page_title NOT REGEXP '_\\([a-z]+\\)' AND
	pl_from=pf.page_id AND
	pf.page_latest=rev_id
ORDER BY rev_timestamp DESC
LIMIT 50*/
SQL

Checking query status...
