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 (
55682, 55702, 55815, 57053, 57154, 57155,
57417, 57418, 57557, 57566, 57612,
57701, 57726, 57727, 57747, 57904,
57905, 57923, 57924, 57944, 57945,
57946, 57968, 58029, 58202, 58233,
58234, 58235, 58236, 58237, 58238,
58311, 58312, 58313, 58314, 58315,
58330, 58331, 58337, 58339
)