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 (
    1194, 1195, 1192, 1193, 1295, 1293, 1156, 
    1188, 1189, 1187, 1190, 1191, 1365, 
    614, 696, 1280, 1279, 1000, 699, 1132, 
    1129, 1196, 1197, 1149, 1363, 1315, 
    955, 1154, 1155, 1366, 861, 485, 484, 
    968, 1165, 1198, 1301, 1215, 1214, 1216, 
    643, 644, 1122, 1125, 727, 584, 1222, 
    1223, 690, 535, 622, 1182, 1183, 859, 
    969, 1262, 1260, 971, 1169, 595, 647, 
    693, 732, 621, 1128, 1008, 970, 981
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id