Untitled query #49863

SQL

USE wikidatawiki_p;
SELECT CONCAT("Q",descriptions.term_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
		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 = descriptions.term_entity_id
		AND (labels.term_language IS NULL OR english.term_language <> descriptions.term_language)
		AND english.term_entity_type = descriptions.term_entity_type
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_entity_id, descriptions.term_language;
SQL

Checking query status...
