wikidata: counts of all uk labels

SQL

SELECT CONCAT('https://www.wikidata.org/wiki/Q', MIN(wbt_item_terms.wbit_item_id)) as Q_id, 
       wbt_text.wbx_text as label, 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 wbt_term_in_lang.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
group by wbt_text.wbx_text order by cnt desc, wbt_text.wbx_text
SQL

Checking query status...
