SELECT
option_id,
option_type
FROM
cscart_product_options
INNER JOIN cscart_ult_objects_sharing ON (
cscart_ult_objects_sharing.share_object_id = cscart_product_options.option_id
AND cscart_ult_objects_sharing.share_company_id = 1
AND cscart_ult_objects_sharing.share_object_type = 'product_options'
)
WHERE
option_id IN (
10310, 10311, 10312, 10313, 10314, 10315,
10316, 10317, 10319, 10320, 10321,
10322, 10324, 10325, 10326, 10327,
10328, 10329, 10330, 10331, 10344,
10360, 10372, 10379, 10381, 10382,
10385, 10387, 10389, 10445, 10452,
10464, 10465, 10475, 10476, 18471,
18478, 33875, 71392, 71393
)