use tewiki_p;

select concat("[[",page_title,"|",page_title,"]]"),count(pl_title) from pagelinks,page

#join page on page_id=pl_from

where page_title = pl_title

        and page_namespace=0

        and pl_namespace=0

        and page_id in (select pp_page from page_props where pp_propname ="disambiguation")

 group by pl_title

-- having count(page_title) < 4

order by count(pl_title) desc

#and catl.cl_type = "page"

#group by p.page_id

#order by pl_title