SELECT 
  a.variant_id, 
  a.option_id, 
  a.position, 
  a.modifier, 
  a.modifier_type, 
  a.weight_modifier, 
  a.weight_modifier_type, 
  b.variant_name, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier, 
    a.modifier
  ) as modifier, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier_type, 
    a.modifier_type
  ) as modifier_type 
FROM 
  cscart_product_option_variants as a 
  LEFT JOIN cscart_product_option_variants_descriptions as b ON a.variant_id = b.variant_id 
  AND b.lang_code = 'fr' 
  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id 
  AND shared_option_variants.company_id = 3 
WHERE 
  a.option_id IN (
    1132, 1129, 955, 1154, 1155, 1149, 1366, 
    643, 644, 1122, 1125, 690, 221, 859, 
    1262, 1260, 732, 1128, 981, 1123, 1310, 
    1101, 860, 510, 526, 1111, 1116, 1097, 
    1113, 521, 1120, 1118, 1098, 1263, 1261, 
    1103, 1126, 1112, 1110, 1109, 1133, 
    1130, 1160, 1159, 1121, 1100, 1117, 
    1104, 1108, 1119, 1102, 1115, 1226, 
    1107, 1224, 1114, 1225, 857, 1105, 1307, 
    560, 719, 1227, 1106, 1136, 1158, 1161, 
    1312, 1313, 1164, 1138, 523, 1142, 762, 
    1141, 1137, 1140
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id