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 (
83143, 83145, 83147, 83171, 83321, 83322,
83323, 83352, 83353, 83354, 83355,
83356, 83357, 83358, 83359, 83360,
83361, 83362, 83363, 83364, 83365,
83366, 83367, 83368, 83558, 83561,
83562, 83622, 83634, 83635, 83636,
83637, 83668, 83669, 83670, 83714,
83717, 83718, 83719, 83721
)