use hewiki_p;

select page_title, count(pl_title) from pagelinks join page

on pl_from = page_id

where page_namespace = 0

and pl_namespace = 0

and page_is_redirect = 0

group by pl_from

limit 10

​