T103836 - Quarry

SQL

USE wikidatawiki_p;
/*
SELECT descriptions.term_full_entity_id AS item, #english.term_text AS english_label,
	labels.term_text AS label, descriptions.term_language AS lang, descriptions.term_text AS description
	FROM wb_terms AS descriptions
	LEFT JOIN wb_terms AS labels USING (term_full_entity_id, term_language)
	#LEFT JOIN (SELECT * FROM wb_terms WHERE term_language = "en" AND term_type = "label") AS english USING (term_full_entity_id)
WHERE labels.term_type = 'label'
AND descriptions.term_type = "description"
AND (descriptions.term_text RLIKE "[Qq][1-9][0-9]{3}" OR descriptions.term_text LIKE "%P[1-9][0-9]%")
#ORDER BY descriptions.term_full_entity_id, descriptions.term_language;
LIMIT 10;*/

SELECT CONCAT('Q', wbit_item_id) AS full_entity_id, wbxl_language, wbx_text
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbtl_id = wbit_term_in_lang_id
JOIN wbt_text_in_lang ON wbxl_id = wbtl_text_in_lang_id
JOIN wbt_type ON wby_id = wbtl_type_id
JOIN wbt_text ON wbx_id = wbxl_text_id
WHERE wby_name = 'description'
AND (wbx_text RLIKE "[Qq][1-9][0-9]{3}" OR wbx_text RLIKE "P[1-9][0-9]")
LIMIT 1;
SQL

Checking query status...
