Untitled query #20124

SQL

USE wikidatawiki_p;
SELECT 
CONCAT("Q",english.term_entity_id) AS item,
 english.term_text AS label,
 arabic.term_text AS arl, 
 des.term_text AS label2, 
CONCAT("Q",des.term_entity_id) AS item2

	FROM (SELECT * FROM wb_terms 
          WHERE term_type = "label" #  "description" 
           And  term_language = "en"
          AND term_entity_type = "item"
         ) AS des
	LEFT JOIN (SELECT * FROM wb_terms
               WHERE term_language = "ar"
               AND term_type = "label"
              ) AS arabic
        LEFT JOIN (SELECT * FROM wb_terms
               WHERE term_language = "en"
               AND term_type = "label"
              ) AS english
		ON english.term_entity_id != des.term_entity_id
	
#    and english.term_language <> des.term_language

 Where arabic.term_entity_type = des.term_entity_type
And des.term_text =  english.term_text
#RLIKE "[Qq][1-9][0-9]{3}" OR descriptions.term_text LIKE "%P[1-9][0-9]%"



#ORDER BY des.term_entity_id, des.term_language
Limit   10;

###
SQL

Checking query status...
