Persons lacking English description

SQL

# Draft — stil figuring this out!
#SELECT CONCAT("Q",wbit_item_id), wbit_term_in_lang_id
#FROM wbt_item_terms 
#LIMIT 10

SELECT
  CONCAT("Q", 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 AND wby_name = 'label' AND wbxl_language = 'pt';

SQL

Checking query status...