use eswiki_p;

select cl_to, count(cl_from)

from categorylinks

join page p on p.page_namespace=0 and cl_from=p.page_id

group by cl_to

order by count(cl_from) desc

limit 1000;