TEST 7 - Quarry

SQL

SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id, wbxl_language, 
(SELECT wbx_text FROM wbt_text WHERE wbx_id = wbxl_text_id) AS text
FROM wbt_item_terms   AS Lwbit
JOIN wbt_term_in_lang AS Lwbtl ON Lwbtl.wbtl_id = Lwbit.wbit_term_in_lang_id
JOIN wbt_type         AS Ly    ON Ly.wby_id = Lwbtl.wbtl_type_id
JOIN wbt_item_terms   AS Dwbit ON Dwbit.wbit_item_id = Lwbit.wbit_item_id
JOIN wbt_term_in_lang AS Dwbtl ON Dwbtl.wbtl_id = Dwbit.wbit_term_in_lang_id
JOIN wbt_type         AS Dy    ON Dy.wby_id = Dwbtl.wbtl_type_id
JOIN wbt_text_in_lang          ON wbxl_id = Dwbtl.wbtl_text_in_lang_id
#JOIN wbt_text                  ON wbx_id = wbxl_text_id
WHERE Ly.wby_name = 'label' AND Dy.wby_name = 'description'
AND Lwbtl.wbtl_text_in_lang_id = Dwbtl.wbtl_text_in_lang_id
AND wbxl_language = 'ar'
LIMIT 25;
SQL

Checking query status...
