SELECT 
  a.variant_id, 
  a.option_id, 
  a.position, 
  a.modifier, 
  a.modifier_type, 
  a.weight_modifier, 
  a.weight_modifier_type, 
  a.nav_skus, 
  a.commercial_modifier, 
  a.commercial_dn, 
  a.same_as_option, 
  a.price_overrides, 
  a.base_cost, 
  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 = 'en' 
  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 = 1 
WHERE 
  a.option_id IN (
    22908, 22117, 22909, 22907, 22598, 22599, 
    22911, 22912, 22594, 22595, 22596, 
    21941
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00272

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "shared_option_variants",
      "access_type": "system",
      "possible_keys": ["PRIMARY", "company_id"],
      "rows": 0,
      "filtered": 0,
      "const_row_not_found": true
    },
    "read_sorted_file": {
      "filesort": {
        "sort_key": "a.position, a.variant_id",
        "table": {
          "table_name": "a",
          "access_type": "range",
          "possible_keys": ["option_id", "option_id_2", "status"],
          "key": "option_id",
          "key_length": "6",
          "used_key_parts": ["option_id", "status"],
          "rows": 226,
          "filtered": 100,
          "index_condition": "a.option_id in (22908,22117,22909,22907,22598,22599,22911,22912,22594,22595,22596,21941) and a.`status` = 'A'"
        }
      }
    },
    "table": {
      "table_name": "b",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["variant_id", "lang_code"],
      "ref": ["cscart_migrate.a.variant_id", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(b.lang_code = 'en')"
    }
  }
}

Result

variant_id option_id position modifier modifier_type weight_modifier weight_modifier_type nav_skus commercial_modifier commercial_dn same_as_option price_overrides base_cost variant_name
220137 22117 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
220318 21941 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
222979 22594 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
222984 22595 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
222989 22596 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
223024 22598 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
223060 22599 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
228024 22907 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
228031 22908 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
228032 22909 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
228071 22911 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
228102 22912 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
222993 22598 2 0.000 A 0.000 A 0.00 0.00 22117 0.00 Same as Shade
215376 21941 3 0.000 A 0.000 A E26 0.00 0.00 0 0.00 E26
222975 22594 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
222980 22595 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
222985 22596 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
227995 22907 3 11.000 A 0.000 A G26 0.00 0.00 0 0.00 G26 Gooseneck Arm
228072 22912 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
215377 21941 5 14.000 A 0.000 A GU24 0.00 0.00 0 3.50 GU24
222976 22594 5 39.000 A 0.000 A DBPC 0.00 0.00 0 0.00 Decorative BP Cover
222983 22595 5 110.000 A 0.000 A DCHX 0.00 0.00 0 0.00 Copper BP & Hex Cover
222988 22596 5 121.000 A 0.000 A DCHX 0.00 0.00 0 0.00 Brass BP & Hex Cover
227996 22907 5 12.000 A 0.000 A G11 0.00 0.00 0 0.00 G11 Gooseneck Arm
228026 22908 5 0.000 A 0.000 A VDBW10 0.00 0.00 0 0.00 10" Shade
228033 22909 5 0.000 A 0.000 A VC 0.00 0.00 0 0.00 Circle Vent
228069 22911 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
228073 22912 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
233540 22594 8 61.000 A 0.000 A DCHX 0.00 0.00 0 0.00 Decorative BP & Hex Cover
222977 22594 10 92.000 A 0.000 A DD 0.00 0.00 0 0.00 Dusk-to-Dawn Photocell
222981 22595 10 202.000 A 0.000 A DD 0.00 0.00 0 0.00 Dusk-to-Dawn Photocell
222986 22596 10 213.000 A 0.000 A DD 0.00 0.00 0 0.00 Dusk-to-Dawn Photocell
227997 22907 10 15.000 A 0.000 A G15 0.00 0.00 0 0.00 G15 Gooseneck Arm
228027 22908 10 24.000 A 0.000 A VDBW12 0.00 0.00 0 0.00 12" Shade
228034 22909 10 0.000 A 0.000 A VS 0.00 0.00 0 0.00 Narrow Slot Vent
228070 22911 10 49.000 A 0.000 A WC 0.00 0.00 0 0.00 Wire Cage
228074 22912 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
222978 22594 15 83.000 A 0.000 A HDBP 0.00 0.00 0 0.00 Heavy Duty BP
222982 22595 15 83.000 A 0.000 A HDBP 0.00 0.00 0 0.00 Heavy Duty BP
222987 22596 15 83.000 A 0.000 A HDBP 0.00 0.00 0 0.00 Heavy Duty BP
227998 22907 15 17.000 A 0.000 A G22 0.00 0.00 0 0.00 G22 Gooseneck Arm
228028 22908 15 36.000 A 0.000 A VDBW14 0.00 0.00 0 0.00 14" Shade
228075 22912 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
228018 22907 18 14.000 A 0.000 A G8 0.00 0.00 0 0.00 G8 Gooseneck Arm
227999 22907 20 26.000 A 0.000 A G24 0.00 0.00 0 0.00 G24 Gooseneck Arm
228029 22908 20 47.000 A 0.000 A VDBW16 0.00 0.00 0 0.00 16" Shade
228076 22912 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
228000 22907 25 26.000 A 0.000 A G6 0.00 0.00 0 0.00 G6 Gooseneck Arm
228030 22908 25 82.000 A 0.000 A VDBW20 0.00 0.00 0 0.00 20" Shade
228077 22912 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
217978 22117 26 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
237170 22912 27 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
217979 22117 28 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
223030 22599 28 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
237171 22912 28 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
217980 22117 30 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
223031 22599 30 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
228001 22907 30 0.000 A 0.000 A G3 0.00 0.00 0 0.00 G3 Straight Arm
228078 22912 30 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
238318 22908 30 143.000 A 0.000 A VDBW24 0.00 0.00 0 0.00 24" Shade
242721 22912 31 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
217981 22117 32 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
222994 22598 32 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
223032 22599 32 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
241120 22912 33 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
217982 22117 34 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
222995 22598 34 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
223033 22599 34 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
228002 22907 35 0.000 A 0.000 A G4 0.00 0.00 0 0.00 G4 Straight Arm
228079 22912 35 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
217983 22117 36 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
222996 22598 36 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
223034 22599 36 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
222997 22598 38 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
223054 22599 38 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
237042 22117 38 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
222998 22598 40 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
223035 22599 40 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
228003 22907 40 4.000 A 0.000 A G1 0.00 0.00 0 0.00 G1 Straight Arm
228080 22912 40 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
237043 22117 40 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
217984 22117 42 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
223018 22598 42 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
237046 22599 42 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
222999 22598 44 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
237047 22599 44 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
242635 22117 44 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
228004 22907 45 4.000 A 0.000 A G14 0.00 0.00 0 0.00 G14 Straight Arm
228081 22912 45 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
223036 22599 46 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
237044 22598 46 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
241100 22117 46 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
217985 22117 48 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
237045 22598 48 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
242885 22599 48 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
217986 22117 50 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
223000 22598 50 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
228005 22907 50 2.000 A 0.000 A G16 0.00 0.00 0 0.00 G16 Straight Arm
228082 22912 50 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
241131 22599 50 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
217987 22117 52 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
223037 22599 52 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
242881 22598 52 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
217988 22117 54 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
223038 22599 54 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
241125 22598 54 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
228006 22907 55 2.000 A 0.000 A G17 0.00 0.00 0 0.00 G17 Straight Arm
228083 22912 55 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
217989 22117 56 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
223001 22598 56 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
223039 22599 56 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
223002 22598 58 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
223040 22599 58 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
241101 22117 58 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241121 22912 58 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
217990 22117 60 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
223003 22598 60 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
223041 22599 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
228007 22907 60 26.000 A 0.000 A G35 0.00 0.00 0 0.00 G35 Gooseneck Arm
228084 22912 60 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
223004 22598 62 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
241132 22599 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
223005 22598 64 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
217991 22117 65 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
223042 22599 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
228008 22907 65 30.000 A 0.000 A G34 0.00 0.00 0 0.00 G34 Gooseneck Arm
228085 22912 65 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
241126 22598 66 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
223006 22598 68 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
217992 22117 70 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
223007 22598 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
223043 22599 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
228009 22907 70 16.000 A 0.000 A G5 0.00 0.00 0 0.00 G5 Gooseneck Arm
228086 22912 70 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
217993 22117 75 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
223008 22598 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
223044 22599 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
228010 22907 75 21.000 A 0.000 A G25 0.00 0.00 0 0.00 G25 Gooseneck Arm
228087 22912 75 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
217994 22117 80 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
223009 22598 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
223045 22599 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
228011 22907 80 28.000 A 0.000 A G10 0.00 0.00 0 0.00 G10 Gooseneck Arm
228088 22912 80 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
217995 22117 85 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
223010 22598 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
223046 22599 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
228012 22907 85 97.000 A 0.000 A G19 0.00 0.00 0 0.00 G19 Gooseneck Arm
228089 22912 85 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
217996 22117 90 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
223011 22598 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
223047 22599 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
228013 22907 90 190.000 A 0.000 A G65 0.00 0.00 0 0.00 G65 Gooseneck Arm
228090 22912 90 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
217997 22117 95 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
223012 22598 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
223048 22599 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
228014 22907 95 158.000 A 0.000 A G64 0.00 0.00 0 0.00 G64 Gooseneck Arm
228091 22912 95 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241102 22117 98 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241122 22912 98 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
217998 22117 100 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
223013 22598 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
223049 22599 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
228015 22907 100 8.000 A 0.000 A G12 0.00 0.00 0 0.00 G12 Gooseneck Arm
228092 22912 100 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241103 22117 103 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241127 22598 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241133 22599 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
217999 22117 105 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
223014 22598 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
223050 22599 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
228016 22907 105 10.000 A 0.000 A G13 0.00 0.00 0 0.00 G13 Gooseneck Arm
241123 22912 105 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241128 22598 107 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241134 22599 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
218000 22117 110 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
223015 22598 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
223051 22599 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
228017 22907 110 23.000 A 0.000 A G32 0.00 0.00 0 0.00 G32 Gooseneck Arm
228093 22912 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
223052 22599 112 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
242636 22117 112 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
223016 22598 113 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
242637 22117 113 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
242886 22599 114 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
218001 22117 115 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
228094 22912 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
242882 22598 115 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242722 22912 116 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242883 22598 116 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
242887 22599 116 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
234094 22598 117 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
234095 22599 117 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
234093 22598 118 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
234096 22599 118 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
242723 22912 118 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
218002 22117 120 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
223017 22598 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
223053 22599 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
228019 22907 120 35.000 A 0.000 A G2 0.00 0.00 0 0.00 G2 Gooseneck Arm
228095 22912 120 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
242888 22599 121 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241135 22599 122 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
218003 22117 125 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
228020 22907 125 39.000 A 0.000 A G36 0.00 0.00 0 0.00 G36 Gooseneck Arm
228096 22912 125 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
242884 22598 125 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
242638 22117 126 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241104 22117 128 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
228021 22907 130 25.000 A 0.000 A G7 0.00 0.00 0 0.00 G7 Gooseneck Arm
228097 22912 130 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
241130 22598 130 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242724 22912 132 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241124 22912 133 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
228022 22907 135 32.000 A 0.000 A G9 0.00 0.00 0 0.00 G9 Gooseneck Arm
228023 22907 140 141.000 A 0.000 A G40 0.00 0.00 0 0.00 G40 Gooseneck Arm
218008 22117 150 160.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
223022 22598 150 125.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
223058 22599 150 125.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
218009 22117 155 200.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
223023 22598 155 125.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
223059 22599 155 125.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
218010 22117 160 250.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
218011 22117 165 210.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
218012 22117 170 250.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass