Untitled query #8756

SQL

use enwiki_p;
select #concat('[[:de:',p.page_title,'|',p.page_title,']]') as dewiki, concat('[[',p.page_title,']]') as enwiki, count(l.ll_lang) as 'number of iw'
#concat('* [[:ltg:',p.page_title,'|',p.page_title,']] - [[',p.page_title,']] - ',count(l.ll_lang))
p.page_title, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where  l.ll_from in (select p.page_id from pagelinks pl
						join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
						where pl.pl_from=37800330 and pl.pl_namespace=0)
and 
p.page_namespace=0 and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv")
group by l.ll_from
#having count(l.ll_lang)>20
order by count(l.ll_lang) desc
limit 600;
SQL

Checking query status...
