SELECT 
  v.variant_id as id, 
  d.variant_name as name, 
  o.option_id as option_id, 
  i.option_name as option_name, 
  v.position as position, 
  v.nav_skus, 
  v.image_size, 
  v.modifier, 
  v.modifier_type, 
  v.commercial_modifier, 
  v.commercial_dn, 
  v.extra_details, 
  v.vertical_position, 
  v.separator_label, 
  v.lead_time, 
  v.base_cost, 
  v.same_as_option, 
  v.price_overrides, 
  (
    select 
      0
  ) as is_global 
FROM 
  cscart_product_option_variants as v 
  INNER JOIN cscart_product_option_variants_descriptions as d 
  INNER JOIN cscart_product_options as o 
  INNER JOIN cscart_product_options_descriptions as i 
  INNER JOIN cscart_products as p ON v.variant_id = d.variant_id 
  AND o.option_id = i.option_id 
  AND o.option_id = v.option_id 
  AND o.product_id = p.product_id 
WHERE 
  p.product_id = 65892 
  AND o.option_id = 23188 
  AND v.status = 'A' 
ORDER BY 
  option_name ASC, 
  name ASC