This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

x
 
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;
###
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...