Untitled query #42954

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;
SQL

Checking query status...
