nds_nlwiki Links to disambiguation pages

SQL

USE nds_nlwiki_p;
SELECT page_namespace, page_title, COUNT(pl_from) AS 'count'
FROM (
  SELECT dp.page_namespace, dp.page_title, pl_from
  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'
  UNION
  SELECT dp.page_namespace, dp.page_title, pl_from
  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
ORDER BY `count` DESC
LIMIT 50
SQL

Checking query status...
