select now();

#v2

#User:Power~enwiki/Cities

select p.page_title, count(l.ll_lang),

    (SELECT GROUP_CONCAT(tl_title SEPARATOR '|') FROM templatelinks

            WHERE tl_namespace = 10 and tl_from=p.page_id and tl_title like "Infobox%") as box

from langlinks l

join page p on p.page_id=l.ll_from

where exists (select * from pagelinks pl

                        join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace

                        where p.page_id=l.ll_from and pl.pl_from=54229159 and pl.pl_namespace=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

order by count(l.ll_lang) desc;