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 ON wbit_term_in_lang_id = wbtl_id
JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id AND wbxl_language = 'en'
LEFT JOIN wbt_text wbt_text_name ON wbxl_text_id = wbt_text_name.wbx_id AND wbtl_type_id = 1 
LEFT JOIN wbt_text wbt_text_desc ON wbxl_text_id = wbt_text_desc.wbx_id AND wbtl_type_id = 2
WHERE wbit_item_id IN (1016099, 67, 1000134)
LIMIT 100
SQL

Checking query status...
