futbolisti pēc navbox līgas

SQL

select now();
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 distinct pl_title
from pagelinks pl
join categorylinks cl on cl.cl_from=pl.pl_from and cl.cl_to="La_Liga_football_club_squad_templates" and pl.pl_from_namespace=10 and pl.pl_namespace=0
)
		#where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="WikiProject_Russia_articles")
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)>20
order by count(l.ll_lang) desc
limit 5000;
SQL

Checking query status...
