Untitled query #40962

SQL

use enwiki_p;
select ll_from, langs
from (
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'))
group by l.ll_from
union
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 templatelinks tl where l.ll_from=tl.tl_from and tl_namespace=10 and tl.tl_from_namespace=0 and tl.tl_title='Infobox_park')
  group by l.ll_from) tablea
order by langs desc
limit 500
SQL

Checking query status...
