SELECT
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'
WHERE
a.product_id IN (
4970, 4963, 4974, 4978, 4956, 4962, 4959,
12457, 11777, 12268, 12270, 12271,
12272, 12275, 12276, 12255, 12257,
12258, 12259, 12260, 12261, 12262,
12269, 12263, 12264, 12265, 12266,
12267, 12273, 12274
)
AND a.status = 'A'
ORDER BY
a.position