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 (
42528, 42529, 42586, 42587, 42617, 42635,
42637, 42638, 42639, 42640, 42641,
42657, 42728, 42737, 42768, 42771,
42772, 42773, 42781, 42782, 42783,
42790, 42791, 42792, 42793, 42794,
42798, 42799, 42800, 42801, 42802,
42805, 42806, 42810, 42811, 42812,
42831, 42836, 42907, 42908, 42909,
42910, 42911, 42912, 42913, 42914,
42915, 42916, 42917, 42918, 42919,
42920, 42921, 42922, 42923, 42924,
42925, 42926, 42927, 42928, 42929,
42930, 42931, 42932, 42933, 42934,
42935, 42936, 42937, 42938, 42939,
42940, 42941, 42942, 43002, 43192,
43193, 43227, 43234, 43433
)