Untitled query #84565

SQL

SELECT *, CONCAT("Q",wbit_item_id) as Item, wbt_text_name.wbx_text as Name#, wbt_text_desc.wbx_text as Description
FROM wbt_item_terms
JOIN wbt_term_in_lang wbt_term_in_lang_name ON wbt_term_in_lang_name.wbtl_id = wbit_term_in_lang_id AND wbt_term_in_lang_name.wbtl_type_id = 1
JOIN wbt_term_in_lang wbt_term_in_lang_desc ON wbt_term_in_lang_desc.wbtl_id = wbit_term_in_lang_id
JOIN wbt_text_in_lang wbt_text_in_lang_name ON wbt_term_in_lang_name.wbtl_text_in_lang_id = wbt_text_in_lang_name.wbxl_id AND wbt_text_in_lang_name.wbxl_language = 'en'
JOIN wbt_text_in_lang wbt_text_in_lang_desc ON wbt_term_in_lang_desc.wbtl_text_in_lang_id = wbt_text_in_lang_desc.wbxl_id AND wbt_text_in_lang_desc.wbxl_language = 'en'
JOIN wbt_text wbt_text_name ON wbt_text_in_lang_name.wbxl_text_id = wbt_text_name.wbx_id
LEFT JOIN wbt_text wbt_text_desc ON wbt_text_in_lang_desc.wbxl_text_id = wbt_text_desc.wbx_id AND wbt_term_in_lang_desc.wbtl_type_id = 2
WHERE wbit_item_id IN (1016099, 67, 1000134)
LIMIT 100
SQL

Checking query status...
