T103836 - Quarry

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q", 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 (SELECT * FROM wb_terms WHERE term_type = "description" AND term_entity_type = "item") AS descriptions
	LEFT JOIN (SELECT * FROM wb_terms WHERE term_type = "label") AS labels USING (term_full_entity_id, term_language)
		#ON labels.term_full_entity_id = descriptions.term_full_entity_id
		#AND labels.term_language = descriptions.term_language
	LEFT JOIN (SELECT * FROM wb_terms WHERE term_language = "en" AND term_type = "label") AS english
		ON english.term_full_entity_id = descriptions.term_full_entity_id
		AND (labels.term_language IS NULL OR english.term_language <> descriptions.term_language)
WHERE 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;
SQL

Checking query status...
