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 (
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 a.product_id = 0
AND status = 'A'
ORDER BY
a.position