Untitled query #63185

SQL

SELECT 
  wbt_item_terms.wbit_item_id AS item, 
  CAST(wbt_text_in_lang.wbxl_language AS CHAR(1000) CHARACTER SET utf8) AS tr,
  CAST(wbt_text.wbx_text AS CHAR(1000) CHARACTER SET utf8) AS current_desc,
  LENGTH(wbt_text.wbx_text) AS strl
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
JOIN wbt_type         ON wbt_term_in_lang.wbtl_type_id = wbt_type.wby_id
JOIN wbt_text         ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
WHERE wbt_text_in_lang.wbxl_language = 'en' 
  AND wbt_type.wby_name = 'description'
  AND (wbt_text.wbx_text LIKE 'a %'
   OR wbt_text.wbx_text LIKE 'an %'
   OR wbt_text.wbx_text LIKE 'A %'
   OR wbt_text.wbx_text LIKE 'An %')
GROUP BY wbt_text.wbx_text, wbt_item_terms.wbit_item_id
ORDER BY wbt_item_terms.wbit_item_id DESC
LIMIT 50000
SQL

Checking query status...
