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 (
    117697, 117699, 117713, 117778, 117835, 
    118017, 118043, 118118, 118195, 118197, 
    118201, 118319, 118320, 118331, 118421, 
    118440, 118477, 118481, 118482, 118577, 
    118590, 118592, 118593, 118860, 118861, 
    118939, 118943, 118997, 118999, 119080
  )