Untitled query #40962

SQL

use enwiki_p;
select ll_from, count(l.ll_lang) as langs
		from langlinks l
		where not exists (select * from langlinks m where m.ll_from=l.ll_from and m.ll_lang='lv')
			and exists ((select l.ll_from from categorylinks cla where cla.cl_type="page" and l.ll_from=cla.cl_from and cla.cl_to in ('2019')) or (select l.ll_from from templatelinks tl where l.ll_from=tl.tl_from and tl_namespace=10 and tl.tl_from_namespace=0 and tl.tl_title='Infobox sportsperson'))
		group by l.ll_from
		order by count(l.ll_lang) desc
		limit 500
SQL

Checking query status...
