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 = 'ru'
LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id
WHERE
c.product_id IN (
8175, 8389, 8390, 8391, 8886, 8553, 8451,
8176, 8961, 8962, 8151, 8152, 14469,
7980, 8154, 8313, 7979, 8256, 14468,
14467, 7685, 7680, 8403, 8143
)
AND a.product_id = 0
AND a.status = 'A'
ORDER BY
a.position