Untitled query #20124

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 = "label" #  "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
		ON  labels.term_language = descriptions.term_language
	
##    AND labels.term_entity_type = descriptions.term_entity_type
        AND labels.term_text = descriptions.term_text 
        
	LEFT JOIN (SELECT * FROM wb_terms WHERE term_language = "ar" 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
Limit   10;

###
SQL

Checking query status...
