Untitled query #8866

SQL

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;
SQL

Checking query status...
