p-v3 - Quarry

SQL

use enwiki_p;
select l.ll_from, count(l.ll_lang)
from langlinks l
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=21258969 and pl.pl_namespace=0)
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv")
# and ll_lang<>"ru"
group by l.ll_from
having count(l.ll_lang)>20
order by count(l.ll_lang) desc
#having l.ll_from not in (select distinct ll_from from langlinks where ll_lang = "ru")
#limit 100;
/*
use lvwiki_p;
select l.ll_from, count(l.ll_lang)
from langlinks l
where  l.ll_from=289120
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv")
# and ll_lang<>"ru"
group by l.ll_from
#having l.ll_from not in (select distinct ll_from from langlinks where ll_lang = "ru")
limit 20;
*/
SQL

Checking query status...
