use plwiki_p;

set @max_links = 5;

​

select page_title, count(distinct pl_title) as n_links

from page inner join pagelinks on pl_from = page_id and pl_from_namespace = 0 and pl_namespace = 0 and page_is_redirect = 0

group by page_id

having n_links <= @max_links and page_id not in (

        select page_id

        from page inner join page_props on pp_page = page_id

        where pp_propname = "disambiguation"

    )

order by page_title;