Untitled query #43392

SQL

use wikidatawiki_p;
SELECT
	concat('P',wbpt_property_id) AS page_title,
	wbx_text as term_text
FROM wbt_property_terms
	INNER JOIN page ON concat('P',wbpt_property_id)=page_title AND page_namespace=120
	INNER JOIN pagelinks ON pl_from=page_id AND page_namespace=120 AND pl_from=page_id and pl_title='P1630' and pl_namespace=120 and pl_from_namespace=120
	INNER JOIN wbt_term_in_lang ON wbpt_term_in_lang_id = wbtl_id AND wbtl_type_id=1 /* label */
	INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id AND wbxl_language='en'
	INNER JOIN wbt_text  ON wbxl_text_id = wbx_id
;
SQL

Checking query status...
