إضافة وصف حسب الوصف الإنجليزي

Fork of wikidata: find by <lang> description (easy) by Renamerr

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

SQL

SELECT CONCAT('Q', wbt_item_terms.wbit_item_id) AS item, 
	"Dar", 		# "Den" sets the description for the language with language code "en" (change here and below)
	"فَصيلة من الثدييات" As NewDescription
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
                     AND wbt_term_in_lang.wbtl_type_id = 2  # 1- label; 2- description; 3- alias
JOIN wbt_text_in_lang ON wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id
                     AND wbt_text_in_lang.wbxl_language = 'en' # <lang>
JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
                     AND wbt_text.wbx_text = 'family of mammals'
LIMIT 100;

SQL

Checking query status...