handle missing lv labels in wikidata

SELECT
  wbit_item_id as id,
  wby_name as type,
  wbxl_language as language,
  wbx_text as text
FROM wbt_item_terms
LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
LEFT JOIN wbt_type ON wbtl_type_id = wby_id
LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
LEFT JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE wbit_item_id = 123;



SELECT
  wbit_item_id as id
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
JOIN wbt_type ON wbtl_type_id = wby_id
JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
WHERE wbit_item_id in (123, 59593107) and wby_name='label' and wbxl_language='lv';

SQL

SELECT
  wbit_item_id as id,
  wby_name as type,
  wbxl_language as language
FROM wbt_item_terms
LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
LEFT JOIN wbt_type ON wbtl_type_id = wby_id and wby_name='label'
LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
WHERE wbit_item_id = 123;

SQL

Checking query status...