Without interwiki articles on ltwiki

SQL

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

SQL

Checking query status...