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_from 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;