nds_nlwiki Links to disambiguation pages

SQL

USE nds_nlwiki_p;
SELECT dp.page_namespace, dp.page_title, COUNT(pl_from) AS 'count'
FROM pagelinks, page dp, page_props
WHERE
	pl_namespace=dp.page_namespace AND
    pl_title=dp.page_title AND
    dp.page_is_redirect=0 AND
    dp.page_id=pp_page AND
    pp_propname='disambiguation'
GROUP BY dp.page_namespace, dp.page_title

UNION

SELECT dp.page_namespace, dp.page_title, COUNT(pl_from) AS 'count'
FROM pagelinks, page rp, redirect, page dp, page_props
WHERE
	pl_namespace=rp.page_namespace AND
    pl_title=rp.page_title AND
    rp.page_is_redirect=1 AND
    rp.page_id=rd_from AND
    rd_namespace=dp.page_namespace AND
    rd_title=dp.page_title AND
    dp.page_id=pp_page AND
    pp_propname='disambiguation'
GROUP BY dp.page_namespace, dp.page_title

/*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...
