Untitled query #34162

SQL

use lvwiki_p;

select page_id, page_title,
	(select m2.ll_title from langlinks m2 where m2.ll_from=p.page_id and m2.ll_lang="en")  as en,
	(select pp.pp_value from page_props pp where pp.pp_page=p.page_id and pp_propname='wikibase_item') as wd,
	(select CONCAT(gt_lat, "|", gl_lon) from geo_tags geo where geo.gt_page_id=p.page_id and gt_primary=1) as coords,
	(SELECT GROUP_CONCAT(tl_title SEPARATOR '|') FROM templatelinks            WHERE tl_title like 'Infobox%' and tl_namespace = 10 and tl_from=p.page_id) as box
	from page p
	where p.page_namespace=0 and p.page_is_redirect=0 and p.page_id in (258326)
SQL

Checking query status...
