nds_nlwiki Links to disambiguation pages

Fork of nlwiki Disambiguation pages without {{dp}} by Bdijkstra

This query is marked as a draft This query has been published by Bdijkstra.

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 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') p
WHERE rd_namespace=page_namespace AND rd_title=page_title
LIMIT 10

SQL

Checking query status...