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 (
614832, 1232975, 588096, 880671, 1088508,
697953, 796373, 591739, 612280, 1120145,
695183, 600012, 614835, 1302601, 590335,
866417, 589124, 696523, 593274, 1232966,
1232977, 696950, 621062, 596399, 588307,
1434961, 590366, 697334, 590358, 594343,
866380, 1233023, 562160, 694679, 595794,
589041
)
AND cscart_ult_product_descriptions.company_id = 1
AND cscart_ult_product_descriptions.lang_code = 'ro'