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
GROUP BY pl_namespace, pl_title
ORDER BY COUNT(pl_from) DESC
LIMIT 50;*/


SELECT page_namespace, page_title, COUNT(pl_from)
FROM pagelinks, page rd, (
    SELECT rd_from
    FROM redirect, (
        SELECT page_namespace, page_title
        FROM page, page_props
        WHERE
            page_is_redirect=0 AND
            page_id=pp_page AND
            pp_propname='disambiguation') dp
	WHERE rd_namespace=page_namespace AND rd_title=page_title) rddp
WHERE
	rd_from=rd.page_id AND
    pl_namespace=rd.page_namespace AND
    pl_title=rd.page_title
GROUP BY pl_namespace, pl_title
ORDER BY COUNT(pl_from) DESC
LIMIT 50;
SQL

Checking query status...
