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 (
    96636, 96635, 96634, 96633, 96632, 96631, 
    96630, 96629, 96628, 96627, 96626, 
    95927, 95925, 95924, 95919, 95918, 
    95917, 95916, 95915, 95914, 95913, 
    95912, 95911, 95910, 95909, 95908, 
    95907, 95906, 95905, 95904, 95903, 
    95902, 95901, 95900, 95899, 96116, 
    96115, 95890, 95889, 95888
  ) 
  AND cscart_product_descriptions.lang_code = 'en'