Get Category Items Without Descriptions in English

SQL

SELECT wbit_item_id  AS id,
       wby_name      AS type,
       wbxl_language AS language,
       wbx_text      AS text
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  wbit_item_id IN (SELECT wbit_item_id AS id
                        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  wby_name = 'description'
                               AND wbxl_language = 'en'
                        GROUP  BY wbit_item_id
                        HAVING Count(*) = 0)
       AND wbxl_language = 'en'
       AND wby_name = 'label'
       AND wbx_text LIKE 'Category:%';
SQL

Checking query status...
