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.