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 (
    955, 1154, 1155, 1149, 1366, 968, 1215, 
    1214, 1216, 727, 584, 1222, 1223, 859, 
    1262, 1260, 981, 860, 510, 526, 521, 
    1263, 1261, 1160, 1159, 1158, 1161, 
    1164, 523
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id