Add Wikidata descriptions based on English description

Fork of Add Wikidata descriptions based on English description by FShbib

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

SQL

USE wikidatawiki_p; 
SELECT CONCAT('Q',term_entity_id,'') AS item,
CONCAT('D',term_language,'') AS term_language, #D (for description) + description language
"سياسي يمني" #new description
FROM wb_terms
WHERE term_type = 'description'
AND term_text LIKE "Member of the Assembly of Representatives of Yemen"
and term_entity_id not in
(select term_entity_id  from wb_terms where term_entity_id = term_entity_id and 
 term_type = "label" and term_language='ar'
and term_entity_id=i.ips_item_id)
#AND term_text LIKE "Yemeni politician"
AND term_entity_type = 'item'
AND term_language = 'en'

SQL

Checking query status...