Untitled query #72508

SQL

SELECT * # wbt_item_terms.wbit_term_id, wbt_text.wbx_text as description, wbt_text_in_lang.wbxl_language
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
JOIN wbt_text_in_lang ON wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id
                     #AND wbt_text_in_lang.wbxl_language = 'ru'
#JOIN wbt_type         ON wbt_term_in_lang.wbtl_type_id = wbt_type.wby_id
#                     AND wbt_type.wby_name = 'alias'
JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
where wbt_term_in_lang.wbtl_type_id = 3
limit 100
SQL

Checking query status...
