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 (
1233012, 1067180, 696234, 591722, 589214,
1067678, 1033163, 992088, 1730410,
614833, 600286, 588439, 588446, 589740,
697903, 1067318, 1025367, 695078,
1233020, 599887, 1067521, 588910,
612038, 991897, 590755, 1025365, 622101,
1120163, 697332, 697155, 1073044,
591218, 1070391, 593887, 697609, 991976
)
AND cscart_ult_product_descriptions.company_id = 1
AND cscart_ult_product_descriptions.lang_code = 'ro'