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 (
22662, 22615, 6924, 22761, 22663, 22684,
22664, 22762, 22849, 23007, 22708,
22709, 22710, 22711, 22707, 23529,
22763, 22764, 22765, 22766, 22767,
22768, 22712, 23363
)
AND cscart_product_descriptions.lang_code = 'en'