alswiki displaytitle

SQL

USE alswiki_p;
SELECT P.page_title, items.page_title, term_text, DT.pp_value
FROM page AS P
JOIN page_props AS DT ON DT.pp_page = P.page_id AND DT.pp_propname = 'displaytitle'
JOIN page_props AS WB ON WB.pp_page = P.page_id AND WB.pp_propname = 'wikibase_item'
JOIN wikidatawiki_p.page AS items ON items.page_namespace = 0 AND items.page_title = WB.pp_value
JOIN wikidatawiki_p.wb_terms ON term_full_entity_id = items.page_title
WHERE P.page_namespace = 0 AND term_type = 'label' AND term_language = 'gsw' AND term_text <> DT.pp_value
LIMIT 1;
SQL

Checking query status...
