use huwiki_p;

​

SELECT

    page_title,

    CONCAT( 'https://hu.wikipedia.org/wiki/', page_title ) url,

    count(*) count

FROM

    pagelinks

    JOIN page ON pl_namespace = page_namespace AND pl_title = page_title

    JOIN page_props ON pp_page = page_id

WHERE

    page_namespace = 0 -- sanity check

    AND pp_propname = 'disambiguation'

GROUP BY

    page_namespace,

    page_title

ORDER BY

    count DESC

;