Untitled query #30186

SQL

select now();
#v2
#User:Power~enwiki/Cities
use etwiki_p;
select p.page_title, (select count(l.ll_lang) from langlinks l where p.page_id=l.ll_from) as iws, 
		(select m2.ll_title from langlinks m2 where m2.ll_from=p.page_id and m2.ll_lang="en") as enwiki,
		(select m2.ll_title from langlinks m2 where m2.ll_from=p.page_id and m2.ll_lang="lv") as lvwiki,
	(select pp.pp_value from page_props pp where pp.pp_page=p.page_id and pp_propname='wikibase_item') as wd
from pagelinks pl
						join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
						where pl.pl_from=523457 and pl.pl_namespace=0
                        limit 15;
SQL

Checking query status...
