Cross-wiki categorization

SQL

use enwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join page p on p.page_id=l.ll_from
#where  l.ll_from in (select tl.tl_from from templatelinks tl
#                                               where tl.tl_title="Portail_Lettonie" and tl_namespace=10 and tl.tl_from_namespace=0)
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=0 and cla.cl_type="page" and cla.cl_to="UEFA_Euro_2016_players")
                                              and l.ll_from in (select m.ll_from from langlinks m where m.ll_lang="lv")
and l.ll_lang="lv"
group by l.ll_from
#having count(l.ll_lang)>10
#order by count(l.ll_lang) desc
SQL

Checking query status...
