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 = 'en' 
  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 (
    1336, 1837, 1820, 1304, 1738, 1893, 1895, 
    1894, 1641, 1500, 1317, 1670, 1658, 
    1558, 1644, 1262, 1552, 1398, 1595, 
    1576, 1870, 1691, 1776, 1785, 1633, 
    1563, 1564, 1667, 1786, 1945, 1910, 
    1787, 1308, 1642, 1772, 1736, 1277, 
    1672, 1325, 1665, 1778, 1775, 1671, 
    1649, 1909, 1948, 1612, 1267
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position