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 (
89077, 89078, 89079, 89080, 89081, 89082,
89083, 89084, 89085, 89086, 89087,
89088, 89089, 89090, 89091, 89092,
89093, 89094, 89095, 89096, 89097,
89098, 89099, 89100, 89101, 89102,
89103, 89104, 89105, 89106, 89107,
89108, 89109, 89178, 89336, 89337,
89686, 89687, 89688, 89689
)