Untitled query #37988

SQL

USE enwiki_p;
SELECT page_id, pp1.pp_value shortdesc, pp2.pp_value item FROM page
JOIN page_props pp1 ON pp1.pp_page=page_id AND pp1.pp_propname="wikibase-shortdesc"
JOIN page_props pp2 ON pp2.pp_page=page_id AND pp2.pp_propname="wikibase_item"
JOIN templatelinks ON tl_from=page_id AND tl_namespace=10 AND tl_title="Short_description"
LEFT JOIN wikidatawiki_p.wb_terms wt ON wt.term_full_entity_id=pp2.pp_value AND term_language="en" AND term_type="description"
WHERE page_namespace=0 AND wt.term_full_entity_id is NULL
SQL

Checking query status...
