wikidata: find by <lang> description (easy)

SQL

SELECT CONCAT('http://www.wikidata.org/entity/Q', wbt_item_terms.wbit_item_id) as p,     
    '' as pТМП1, '' as pТМП2, 'категорія проєкту Вікімедіа' as new_text
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
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 = 'uk'
JOIN wbt_type         ON wbt_term_in_lang.wbtl_type_id = wbt_type.wby_id
                     AND wbt_type.wby_name = 'description'
JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
                     AND wbt_text.wbx_text = 'Категорія в проєкті Вікімедіа'
LIMIT 450000;
SQL

Checking query status...
