SELECT
cscart_ult_product_descriptions.product_id,
cscart_ult_product_descriptions.short_description,
IF(
cscart_ult_product_descriptions.short_description = "",
cscart_ult_product_descriptions.full_description,
""
) AS full_description,
cscart_ult_product_descriptions.meta_keywords,
cscart_ult_product_descriptions.meta_description,
cscart_ult_product_descriptions.search_words,
cscart_ult_product_descriptions.promo_text
FROM
cscart_ult_product_descriptions
WHERE
cscart_ult_product_descriptions.product_id IN (
44606, 44605, 31999, 40482, 40707, 40573,
32004, 40644, 40387, 40196, 40210,
40190, 40191, 38805, 38664, 31243,
32005, 39445, 39450, 39371, 38851,
35801, 31252, 36021, 37528, 30880,
30895, 30906, 30912, 30921
)
AND cscart_ult_product_descriptions.company_id = 1
AND cscart_ult_product_descriptions.lang_code = 'fr'