Untitled query #31767

SQL

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
SQL

Checking query status...
