SELECT
c.product_id AS cur_product_id,
a.*,
b.option_name,
b.option_text,
b.description,
b.inner_hint,
b.incorrect_message,
b.comment
FROM
cscart_product_options as a
LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id
AND b.lang_code = 'ro'
LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id
WHERE
c.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 a.product_id = 0
AND status = 'A'
ORDER BY
a.position