SELECT 
  a.*, 
  b.option_name, 
  b.internal_option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  cscart_product_options as a 
  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'ru' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = a.option_id 
    AND cscart_ult_objects_sharing.share_company_id = 1 
    AND cscart_ult_objects_sharing.share_object_type = 'product_options'
  ) 
WHERE 
  a.product_id IN (
    51567, 51565, 51564, 139, 129, 51566, 
    51301, 51, 50, 51497, 51498, 53, 22713, 
    21, 22714, 22712, 46, 22715, 22716, 
    51496, 21567, 91, 50989, 47, 105, 48, 
    49, 92, 137, 88, 126, 31, 51358, 115, 
    37, 11, 140, 41, 30, 90, 38, 124, 81, 56, 
    135, 82, 116, 117, 125, 106, 39, 193, 
    65, 40, 22710, 22711, 17, 57, 122, 58, 
    5, 22, 18, 27
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position