nds_nlwiki Links to disambiguation pages

SQL

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

UNION*/

SELECT dp.page_namespace, dp.page_title, rd_namespace,rd_title#COUNT(pl_from) AS 'count'
FROM page dp, page_props, pagelinks, redirect, page pf
WHERE
    dp.page_id=pp_page AND
    pp_propname='disambiguation' AND
    pl_namespace=dp.page_namespace AND
    pl_title=dp.page_title AND
    pl_from=rd_from AND
    rd_namespace=pf.page_namespace AND
    rd_title=pf.page_title
GROUP BY pl_namespace, pl_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...
