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 (
    48128, 48222, 48230, 48231, 48232, 48236, 
    48243, 48244, 48245, 48246, 48247, 
    48248, 48249, 48250, 48265, 48278, 
    48284, 48350, 48351, 48354, 48376, 
    48377, 48378, 48379, 48396, 48415, 
    48418, 48423, 48479, 48483, 48535, 
    48536, 48537, 48550, 48551, 48552, 
    48597, 48637, 48638, 48640, 48642, 
    48643, 48680, 48683, 48684, 48685, 
    48686, 48817, 48818, 48819, 48820, 
    48821, 48822, 48823, 48824, 48825, 
    48826, 48827, 48828, 48829, 48830, 
    48831, 48832, 48833, 48834, 48835, 
    48836, 48837, 48838, 48839, 48867, 
    48868, 48869, 48870, 48871, 48872, 
    48873, 48874, 48875, 48876
  )