Untitled query #20124

SQL

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

	FROM (SELECT * FROM wb_terms 
          WHERE term_type = "label" #  "description" 
           And  term_language = "ar"
          AND term_entity_type = "item"
         ) AS des

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

Where english.term_entity_type = des.term_entity_type
#WHEREWHERE 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...
