use dewiki_p;

select p.page_title, count(l.ll_lang), (select m2.ll_title from langlinks m2 where m2.ll_from=l.ll_from and m2.ll_lang="en"),

        #(SELECT wb.eu_entity_id from wbc_entity_usage wb where p.page_id=wb.eu_page_id GROUP BY wb.eu_page_id limit 1)

        (SELECT pp.pp_value from page_props pp where pp.pp_page = p.page_id and pp.pp_propname = 'wikibase_item'

         limit 1)

from langlinks l

join page p on p.page_id=l.ll_from

where p.page_is_redirect=0 and p.page_namespace=0 and

not exists (select * from langlinks m where l.ll_from=m.ll_from and m.ll_lang="lv")

group by l.ll_from

having count(l.ll_lang)>49

order by count(l.ll_lang) desc

limit 10000;