SELECT CONCAT('http://www.wikidata.org/entity/Q', wbt_item_terms.wbit_item_id) as p

# SELECT CONCAT('Q', wbt_item_terms.wbit_item_id) as p

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 wbtl_type_id = 1 # 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 = 'uk'

JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id

                     AND wbt_text.wbx_text = 'A'

LIMIT 1000;