wplat - Quarry

SQL

use dawiki_p;
select p.page_title, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where p.page_namespace=0 and p.page_title in (select pla.page_title
		from categorylinks cla
		join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
		where pla.page_namespace=1 and cla.cl_type="page" and (cla.cl_to="Ikke-vurderede_Letlandartikler" or cla.cl_to="Klasse_Start-Letlandartikler" or cla.cl_to="Klasse_Stub-Letlandartikler"))
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv")
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
group by l.ll_from
#having count(l.ll_lang)>3
order by count(l.ll_lang) desc/*
ar veidni:

select p.page_title
from templatelinks pl
join page p on pl.tl_from_namespace=p.page_namespace and p.page_id=pl.tl_from
where pl.tl_from_namespace=1 and pl.tl_title="Статья_проекта_Латвия"
        
ar kategoriju

where p.page_namespace=0 and p.page_title in (select pla.page_title
		from categorylinks cla
		join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
		where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="WikiProject_Linguistics_articles")
*/
SQL

Checking query status...
