USE ltwiki_p;

select

  CONCAT('[[',pl.pl_title,']]') AS "Title",

  page_len AS "Size",

  COUNT(pl.pl_title) AS "Links count"

from pagelinks pl

LEFT JOIN page

ON pl_from = page_id

AND pl_namespace = page_namespace

where 

pl.pl_title IN (Select page_title from page where page_namespace=0) 

and pl.pl_from_namespace=0 and pl.pl_namespace=0

and page_id not in (SELECT ll_from FROM  langlinks) 

AND page_namespace = 0  AND page_is_redirect = 0

group by pl.pl_title

having COUNT(pl.pl_title)>10

ORDER BY COUNT(pl.pl_title) DESC

LIMIT 1000;