wikidata: counts of all uk descriptions

SQL

SELECT wbt_text.wbx_text as description, '' as tmp1, '' as tmp2, count(*) as c
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 = 2  # тоді wbt_type.wby_name = 'description'
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 = 'en'
JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
WHERE wbt_text_in_lang.wbxl_language NOT IN (
  SELECT wbt_text_in_lang.wbxl_language
  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 = 2  # тоді wbt_type.wby_name = 'description'
  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 c desc, wbt_text.wbx_text
limit 500000
SQL

Checking query status...
