hockey - Quarry

SQL

select p.page_title, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where exists (select * from pagelinks pl
						join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
						where p.page_id=l.ll_from and pl.pl_from=53703820 and pl.pl_namespace=0)
and p.page_namespace=0 and not exists (select * from langlinks m where l.ll_from=m.ll_from and m.ll_lang="lv")

and l.ll_from not in (select tl.tl_from from templatelinks tl
                                               where tl.tl_title in ("Infobox_Pro_hockey_team","Infobox_hockey_team") and tl_namespace=10 and tl.tl_from_namespace=0)
group by l.ll_from
order by count(l.ll_lang) desc;
SQL

Checking query status...
