Untitled query #84565

SQL

SELECT CONCAT("Q",wbit_item_id) as Item, name.wbx_text as Name, description.wbx_text as Description
FROM (SELECT wbit_item_id, wbx_text
           FROM wbt_item_terms
           JOIN wbt_term_in_lang ON wbtl_id = wbit_term_in_lang_id AND wbtl_type_id = 1
           JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id AND wbxl_language = "en"
           JOIN wbt_text ON wbxl_text_id = wbx_id
          ) name ON name.wbit_item_id = ips_item_id
LEFT JOIN (SELECT wbit_item_id, wbx_text
           FROM wbt_item_terms
           JOIN wbt_term_in_lang ON wbtl_id = wbit_term_in_lang_id AND wbtl_type_id = 2
           JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id AND wbxl_language = "en"
           JOIN wbt_text ON wbxl_text_id = wbx_id
          ) description ON description.wbit_item_id = ips_item_id
WHERE wbit_item_id IN (1016099, 67, 1000134)
LIMIT 100
SQL

Checking query status...
