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 (
40706, 39407, 40230, 31724, 39680, 39404,
39401, 39406, 39405, 39144, 39403,
40778, 31725, 31727, 30418, 30420,
30413, 30414, 30415, 30416, 30417,
30421, 30423, 31732, 39408, 39409,
39410
)
AND cscart_ult_product_descriptions.company_id = 1
AND cscart_ult_product_descriptions.lang_code = 'fr'