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 (
1660621, 1663150, 1664049, 1658333,
1658334, 1664157, 1658506, 1657840,
1657777, 1658557, 1661197, 1662527,
1658427, 1658811, 1658265, 1663182,
1658593, 1660401, 1658270, 1663613,
1659564, 1658864, 1657833, 1662451,
1661407, 1659246, 1663612, 2099795,
1660547, 1660154, 1659920, 1659832,
1658398, 1658504, 1661697, 1661022
)
AND cscart_ult_product_descriptions.company_id = 1
AND cscart_ult_product_descriptions.lang_code = 'ro'