Untitled query #84565

SQL

SELECT *, CONCAT("Q",wbt_item_terms_name.wbit_item_id) as Item, wbt_text_name.wbx_text as Name, wbt_text_desc.wbx_text as Description
FROM wbt_item_terms wbt_item_terms_name
LEFT JOIN wbt_item_terms wbt_item_terms_desc ON wbt_item_terms_name.wbit_item_id = wbt_item_terms_desc.wbit_item_id
LEFT JOIN wbt_term_in_lang wbt_term_in_lang_name ON wbt_term_in_lang_name.wbtl_id = wbt_item_terms_name.wbit_term_in_lang_id AND wbt_term_in_lang_name.wbtl_type_id = 1
LEFT JOIN wbt_term_in_lang wbt_term_in_lang_desc ON wbt_term_in_lang_desc.wbtl_id = wbt_item_terms_desc.wbit_term_in_lang_id AND wbt_term_in_lang_desc.wbtl_type_id = 2
LEFT 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'
LEFT 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'
LEFT 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
WHERE wbt_item_terms_name.wbit_item_id IN (1016099, 67, 1000134)
LIMIT 100
SQL

Checking query status...
