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 (
1662418, 1659922, 1661347, 1657700,
1658556, 1659797, 1659562, 1657765,
1657745, 1661374, 1915737, 1659943,
1661339, 1659257, 1660558, 1659816,
2591113, 1658321, 1662787, 1664138,
1660123, 1664236, 1661363, 1916044,
1660260, 1657702, 1660929, 1663152,
2596602, 2099753, 1658439, 1663290,
1661128, 1658521, 1658562, 2068216
)
AND cscart_ult_product_descriptions.company_id = 1
AND cscart_ult_product_descriptions.lang_code = 'ro'