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="Archers_at_the_2016_Summer_Olympics"

or cla.cl_to="Athletes_(track_and_field)_at_the_2016_Summer_Olympics"

or cla.cl_to="Badminton_players_at_the_2016_Summer_Olympics"

or cla.cl_to="Canoeists_at_the_2016_Summer_Olympics"

or cla.cl_to="Cyclists_at_the_2016_Summer_Olympics"

or cla.cl_to="Divers_at_the_2016_Summer_Olympics"

or cla.cl_to="Equestrians_at_the_2016_Summer_Olympics"

or cla.cl_to="Field_hockey_players_at_the_2016_Summer_Olympics"

or cla.cl_to="Footballers_at_the_2016_Summer_Olympics"

or cla.cl_to="Golfers_at_the_2016_Summer_Olympics"

or cla.cl_to="Gymnasts_at_the_2016_Summer_Olympics"

or cla.cl_to="Judoka_at_the_2016_Summer_Olympics"

or cla.cl_to="Modern_pentathletes_at_the_2016_Summer_Olympics"

or cla.cl_to="Rowers_at_the_2016_Summer_Olympics"

or cla.cl_to="Rugby_sevens_players_at_the_2016_Olympic_Games"

or cla.cl_to="Sailors_at_the_2016_Summer_Olympics"

or cla.cl_to="Shooters_at_the_2016_Summer_Olympics"

or cla.cl_to="Swimmers_at_the_2016_Summer_Olympics"

or cla.cl_to="Synchronized_swimmers_at_the_2016_Summer_Olympics"

or cla.cl_to="Table_tennis_players_at_the_2016_Summer_Olympics"

or cla.cl_to="Taekwondo_practitioners_at_the_2016_Summer_Olympics"

or cla.cl_to="Tennis_players_at_the_2016_Summer_Olympics"

or cla.cl_to="Triathletes_at_the_2016_Summer_Olympics"

or cla.cl_to="Volleyball_players_at_the_2016_Summer_Olympics"

or cla.cl_to="Weightlifters_at_the_2016_Summer_Olympics"

or cla.cl_to="Wrestlers_at_the_2016_Summer_Olympics"

or cla.cl_to="Beach_volleyball_players_at_the_2016_Summer_Olympics"))

                                              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