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
INNER JOIN cscart_ult_objects_sharing ON (
cscart_ult_objects_sharing.share_object_id = a.option_id
AND cscart_ult_objects_sharing.share_company_id = 1
AND cscart_ult_objects_sharing.share_object_type = 'product_options'
)
WHERE
c.product_id IN (
65260, 65340, 65210, 64553, 65258, 65257,
65256, 65255, 65254, 65253, 65252,
65251, 65250, 65249, 65248, 65247,
65246, 65245, 65244, 65243, 65242,
65241, 65240, 65239, 65238, 65237,
65236, 65235, 65234, 65233, 65232,
65231, 65230, 65229, 65163, 65162,
65161, 65160, 65159, 65114
)
AND a.product_id = 0
AND a.status = 'A'
ORDER BY
a.position