nds_nlwiki Links to disambiguation pages

SQL

USE nds_nlwiki_p;
SELECT page_namespace, page_title, pl_from
FROM page dp, page_props, pagelinks
WHERE
	dp.page_is_redirect=0 AND
    dp.page_id=pp_page AND
    pp_propname='disambiguation' AND
    pl_namespace=dp.page_namespace AND
    pl_title=dp.page_title
LIMIT 10

/*
SELECT page_namespace, page_title, COUNT(pl_from) AS 'count'
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

UNION

SELECT rddp.page_namespace, rddp.page_title, COUNT(pl_from) AS 'count'
FROM pagelinks, page rd, (
    SELECT rd_from, dp.page_namespace, dp.page_title
    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.page_is_redirect=0 AND
    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` DESC
LIMIT 50*/
SQL

Checking query status...
