SELECT CONCAT("* [[", REPLACE(page_title, "_", " "), 

              "]] [http://dispenser.homenet.org/~dispenser/cgi-bin/dablinks.py?lang=nl&limit=50&namespaces=0&ref=", page_title, " "

              , a.blc_count + SUM(IFNULL(b.blc_count,0)), " links]") AS text

FROM page AS dab

JOIN page_props ON pp_page=page_id AND pp_propname="disambiguation"

JOIN u2815__p.backlinkcount_nlwiki_p AS a ON a.blc_from=page_id

LEFT JOIN redirect   ON rd_namespace=dab.page_namespace AND rd_title=dab.page_title

LEFT JOIN u2815__p.backlinkcount_nlwiki_p AS b ON b.blc_from=rd_from

WHERE page_namespace=0

GROUP BY page_id

ORDER BY a.blc_count DESC

LIMIT 100;