USE fawiki_p;

SELECT DISTINCT CONCAT ('# [[',page_title,']]')

FROM pagelinks

INNER JOIN page ON pl_from = page_id

INNER JOIN categorylinks ON page_id = cl_from

WHERE pl_title IN (

  SELECT page_title

  FROM page

  WHERE page_namespace = 0)

  AND pl_namespace = 0

  AND page_id IN (

    SELECT pp_page

    FROM page_props

    WHERE pp_propname = 'disambiguation')

    AND page_namespace = 0

    GROUP BY pl_title

    ORDER BY COUNT(pl_title) DESC

    limit 10;