CONNECT nlwiki_p nlwiki.labsdb;

SELECT CONCAT('* [[', paged.page_title, ']] - ', COUNT(paged.page_title) /*, ' [{{fullurl:Speciaal:VerwijzingenNaarHier|namespace=0&target={{urlencode:', paged.page_title, '|PATH}} }} links]' */ ) FROM page as paged

JOIN page_props AS paged_props ON paged.page_id=paged_props.pp_page 

AND paged_props.pp_propname='disambiguation'

AND paged_props.pp_value='' 

AND paged_props.pp_sortkey IS NULL

JOIN pagelinks AS pagedlinks ON paged.page_title=pagedlinks.pl_title AND pagedlinks.pl_namespace=0 AND pagedlinks.pl_from_namespace=0

JOIN page AS pagea ON pagedlinks.pl_from=pagea.page_id AND pagea.page_namespace=0 AND pagea.page_is_redirect=0

LEFT JOIN page_props AS pagea_props ON pagea.page_id=pagea_props.pp_page 

AND pagea_props.pp_propname='disambiguation' 

AND pagea_props.pp_value='' 

AND pagea_props.pp_sortkey IS NULL

WHERE paged.page_namespace=0 AND paged.page_is_redirect=0 AND pagea_props.pp_page IS NULL

GROUP BY paged.page_title

ORDER BY COUNT(paged.page_title) DESC