SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    111575, 112163, 111572, 111571, 111570, 
    111569, 111568, 111567, 111566, 111565, 
    111564, 111563, 111562, 111561, 111560, 
    125112, 112045, 112044, 112043, 110706
  ) 
  AND cscart_product_descriptions.lang_code = 'en'