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 (
12748, 15130, 2282, 2723, 15152, 15153,
2725, 2728, 2732, 2729, 2722, 15126,
2828, 2714, 2715, 2716, 2717, 2713,
2623, 2622, 15128, 2724, 2726, 2727,
2730, 15151, 15150, 15423, 3216, 2718
)
AND a.status = 'A'
ORDER BY
a.position