Untitled query #33158

SQL

USE enwiki_p;

SELECT page_title,
shortdesc.pp_value,
(select pp_value from page_props where pp_page = page_id and pp_propname = 'wikibase_item') item
from page
INNER JOIN (select * from page_props where pp_propname = 'wikibase-shortdesc') AS shortdesc ON shortdesc.pp_page = page_id 
WHERE
page_namespace = 0 and
page_id IN (select tl_from from templatelinks where tl_namespace = 828 and tl_title = 'Settlement_short_description') and
'description' NOT IN (select term_type from wikidatawiki_p.wb_terms where term_full_entity_id = (select pp_value from page_props where pp_page = page_id and pp_propname = 'wikibase_item') and term_language = 'en')
SQL

Checking query status...
