# https://doc.wikimedia.org/Wikibase/master/php/docs_storage_terms.html

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

       wbt_text.wbx_text as descr, count(*) as cnt

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 = 2   # 2- 'description'

JOIN wbt_text_in_lang on wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id

                     AND wbxl_language = 'uk'

JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id

group by wbt_text.wbx_text order by cnt desc, wbt_text.wbx_text

LIMIT 500000;