Untitled query #20124

SQL

USE wikidatawiki_p;
SELECT 
CONCAT("Q",descriptions.term_entity_id) AS item,
 english.term_text AS english_label,
 descriptions.term_text AS description, 
CONCAT("Q",english.term_entity_id) AS item2

	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_language = "ar"
               AND term_type = "label") AS english
		ON english.term_entity_id != descriptions.term_entity_id
		AND english.term_language <> descriptions.term_language

##    AND english.term_entity_type = descriptions.term_entity_type
WHERE descriptions.term_text =  english.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...
