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 (
54272, 54273, 54274, 54761, 54764, 55352,
55389, 55455, 55632, 55695, 55696,
55697, 55810, 55811, 55881, 55938,
55972, 56013, 56014, 56021, 56126,
56245, 56272, 56356, 56464, 56500,
56501, 56503, 56514, 56515, 56516,
56517, 56518, 56519, 56520, 56521,
56522, 56523, 56524, 56525
)