Untitled query #72777

This query is marked as a draft This query has been published by RPI2026F1.

SQL

SELECT wbit_item_id AS id, wby_name AS type
                        FROM   wbt_item_terms
                               LEFT JOIN wbt_term_in_lang
                                      ON wbit_term_in_lang_id = wbtl_id
                               LEFT JOIN wbt_type
                                      ON wbtl_type_id = wby_id
                               LEFT JOIN wbt_text_in_lang
                                      ON wbtl_text_in_lang_id = wbxl_id
                               LEFT JOIN wbt_text
                                      ON wbxl_text_id = wbx_id
                        WHERE wbxl_language = 'en'
                        GROUP  BY wbit_item_id, wby_name;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...