p-v3 - Quarry

SQL

use enwiki_p;
select l.ll_from, count(l.ll_lang)
from langlinks l
where  l.ll_from in (select tl.tl_from from templatelinks tl
						where tl.tl_title="Designation" and tl_namespace=10 and tl.tl_from_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
/*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=892745 and pl.pl_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

templatelinks

where  l.ll_from in (select tl.tl_from from templatelinks tl
						where tl.tl_title="Infobox_NRHP" and tl_namespace=10 and tl.tl_from_namespace=0)
                   
categorylinks
                   
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=21259008 and pl.pl_namespace=0)
                        
                
vnk pec iw
use enwiki_p;
select l.ll_from, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv") and p.page_namespace=828
group by l.ll_from
#having count(l.ll_lang)>20
order by count(l.ll_lang) desc
limit 50;


standarts - SĀKUMVARIANTS
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=21259008 and pl.pl_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


de->en
use dewiki_p;
select p.page_title, l.ll_from, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en") and p.page_namespace=0
#and l.ll_from=1570903
group by l.ll_from
having count(l.ll_lang)>14
order by count(l.ll_lang) desc
limit 700;
*/
SQL

Checking query status...
