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

and not exists

(select * from page as p1

 where pl_title = p1.page_title

 and p1.page_namespace = 0)

group by pl_from

order by count(pl_title) desc

limit 5

​