T103836 - Quarry

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q",labels.term_entity_id) AS item, English.term_text, labels.term_text, labels.term_language, descriptions.term_text
	FROM (SELECT * FROM wb_terms WHERE term_type = "description") AS descriptions
	JOIN (SELECT * FROM wb_terms WHERE term_type = "label") AS labels
		ON labels.term_entity_id = descriptions.term_entity_id
		AND labels.term_language = descriptions.term_language
		AND labels.term_entity_type = descriptions.term_entity_type
	LEFT JOIN (SELECT * FROM wb_terms WHERE term_language = "en" AND term_type = "label") AS English
		ON English.term_entity_id = labels.term_entity_id
		AND labels.term_language <> English.term_language
		AND English.term_entity_type = descriptions.term_entity_type
WHERE descriptions.term_text RLIKE "\b[Qq][1-9][0-9]";
ORDER BY descriptions.term_entity_id;
SQL

Checking query status...
