Untitled query #69099

SQL

SELECT page_id AS pageId,
       page_title AS title,

  (SELECT m2.ll_title
   FROM langlinks m2
   WHERE m2.ll_from=p.page_id
     AND m2.ll_lang='en') AS en,
     
     
     (select GROUP_CONCAT(distinct lt_title separator '|') from templatelinks
      join linktarget ON tl_target_id = lt_id WHERE lt_title like 'Infobox%' and tl_from=page_id and tl_namespace = 10) as infs

  (SELECT pp.pp_value
   FROM page_props pp
   WHERE pp.pp_page=p.page_id
     AND pp_propname='wikibase_item') AS wikidata
FROM page p
WHERE p.page_namespace=0
  AND p.page_is_redirect=0
  AND p.page_id in (4093660)
SQL

Checking query status...
