SELECT
c.product_id AS cur_product_id,
a.*,
b.option_name,
b.internal_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 = 'en'
LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id
WHERE
c.product_id IN (
4070, 4154, 4144, 4152, 4153, 4029, 4026,
3999, 4003, 4005, 4155, 4156, 4157,
4158, 4159, 4160, 4114, 4112, 4204,
4208, 4209, 4210, 4110, 4111, 4130,
4132, 4133, 4134, 3977, 4055
)
AND a.product_id = 0
AND a.status = 'A'
ORDER BY
a.position