nlwiki Links from templates to disambiguation pages

SQL

SELECT dp_ns, dp_title, COUNT(pl_from) AS 'count',
    GROUP_CONCAT(DISTINCT fp_title SEPARATOR ' | ') AS 'fp_title'
FROM ((
    # direct links from non-redirects to disambiguation pages 
  	SELECT dp.page_namespace AS dp_ns, dp.page_title AS dp_title, pl_from, fp.page_title AS fp_title
    FROM page fp, pagelinks, page dp, page_props
    WHERE
  	  fp.page_namespace=10 AND 
      fp.page_id=pl_from AND fp.page_is_redirect=0 AND
      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 (
    # links from non-redirects to redirects to disambiguation pages
    SELECT dp.page_namespace AS dp_ns, dp.page_title AS dp_title, pl_from, fp.page_title AS fp_title
    FROM page fp, pagelinks, page rp, redirect, page dp, page_props
    WHERE
  	  fp.page_namespace=10 AND 
      fp.page_id=pl_from AND fp.page_is_redirect=0 AND
      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_is_redirect=0 AND dp.page_id=pp_page AND pp_propname='disambiguation'
  )) t
WHERE fp_title NOT REGEXP '^Positiekaart_'
GROUP BY dp_ns, dp_title
ORDER BY `count` DESC
LIMIT 50;
SQL

Checking query status...
