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 (
    23061, 21970, 23065, 23116, 22644, 23039, 
    23068, 23069, 22396, 23070, 23014, 
    23091, 23015, 24039, 24041, 23021, 
    23022, 23023, 22397, 23295, 23016, 
    23024, 23025, 23026
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00280

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": 242,
          "filtered": 100,
          "index_condition": "a.option_id in (23061,21970,23065,23116,22644,23039,23068,23069,22396,23070,23014,23091,23015,24039,24041,23021,23022,23023,22397,23295,23016,23024,23025,23026) 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
218476 21970 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
221143 22396 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
221146 22397 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
223755 22644 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
229895 23014 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
229899 23015 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
229930 23016 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
229983 23021 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
229994 23022 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230005 23023 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230016 23024 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230027 23025 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230038 23026 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230173 23039 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
230439 23061 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
230459 23065 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230474 23068 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
230485 23069 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230497 23070 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
230602 23091 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230828 23116 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
233108 23295 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
245934 24039 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
246007 24041 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
230460 23065 2 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
245511 23014 2 79.000 A 0.000 A M103 50.00 0.00 0 0.00 M103-Black
245935 24039 2 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
215713 21970 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
229896 23015 3 0.000 A 0.000 A WGG 0.00 0.00 0 0.00 Wire Guard
229975 23021 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
229986 23022 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
229997 23023 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
230008 23024 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
230019 23025 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
230030 23026 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
230451 23065 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
230477 23069 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
230489 23070 3 0.000 A 0.000 A 0.00 0.00 0 0.00 None
245981 24041 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
245512 23014 4 79.000 A 0.000 A M200 50.00 0.00 0 0.00 M200-White
245936 24039 4 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
215714 21970 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
221144 22396 5 0.000 A 0.000 A E26 0.00 0.00 0 0.00 Standard Incandescent
221147 22397 5 0.000 A 0.000 A E26 0.00 0.00 0 0.00 Standard Incandescent
223756 22644 5 0.000 A 0.000 A 2700K 0.00 0.00 0 0.00 2700K - Warm White/Soft White
229897 23015 5 5.000 A 0.000 A CGG 0.00 0.00 0 1.29 Cast Guard
229976 23021 5 20.000 A 0.000 A FST 0.00 0.00 0 4.73 Frosted Glass
229987 23022 5 20.000 A 0.000 A FST 0.00 0.00 0 4.73 Frosted Glass
229998 23023 5 20.000 A 0.000 A FST 0.00 0.00 0 4.73 Frosted Glass
230009 23024 5 30.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
230020 23025 5 30.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
230031 23026 5 30.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
230175 23039 5 0.000 A 0.000 A 0.00 0.00 0 0.00 Standard Bulb E26/GU24
230440 23061 5 0.000 A 0.000 A WVG2-RGU 0.00 0.00 0 0.00 Straight Arm
230452 23065 5 20.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
230475 23068 5 0.000 A 0.000 A WVG3-RGU 0.00 0.00 0 0.00 Straight Arm
230478 23069 5 30.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
230490 23070 5 57.000 A 0.000 A 57.00 0.00 0 0.00 LED Silver Bowl G25 - 31-4.5FG25DIM/827/SB/R
230603 23091 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 No Shade
230827 23116 5 0.000 A 0.000 A LED16.8 0.00 0.00 0 0.00 16.8W LED - 1600 Lumen
233109 23295 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 No Shade
245982 24041 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
245513 23014 6 79.000 A 0.000 A M305 50.00 0.00 0 0.00 M305-Forest Green
245937 24039 6 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
245514 23014 8 79.000 A 0.000 A M603 50.00 0.00 0 0.00 M603-Brown
245938 24039 8 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
215715 21970 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
221145 22396 10 40.000 A 0.000 A GU24 0.00 0.00 0 0.00 GU24
221148 22397 10 27.000 A 0.000 A GU24 0.00 0.00 0 1.45 GU24
223757 22644 10 0.000 A 0.000 A 3000K 0.00 0.00 0 0.00 3000K - Neutral White
229977 23021 10 20.000 A 0.000 A RIB 0.00 0.00 0 6.00 Ribbed Glass
229988 23022 10 20.000 A 0.000 A RIB 0.00 0.00 0 6.00 Ribbed Glass
229999 23023 10 20.000 A 0.000 A RIB 0.00 0.00 0 6.00 Ribbed Glass
230010 23024 10 30.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
230021 23025 10 30.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
230032 23026 10 30.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
230174 23039 10 0.000 A 0.000 A 0.00 0.00 0 0.00 Nautical LED
230441 23061 10 30.000 A 0.000 A WVS2-RGU 0.00 0.00 0 0.00 Gooseneck
230453 23065 10 20.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
230476 23068 10 30.000 A 0.000 A WVS3-RGU 0.00 0.00 0 0.00 Gooseneck
230479 23069 10 30.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
230491 23070 10 39.000 A 0.000 A 39.00 0.00 0 0.00 LED Clear ST19 - 31-4.5FSST19DIM/821
230604 23091 10 22.000 A 0.000 A FS 0.00 0.00 0 0.00 Flared Shade
233110 23295 10 22.000 A 0.000 A FS 0.00 0.00 0 0.00 Flared Shade
245515 23014 10 79.000 A 0.000 A M415 50.00 0.00 0 0.00 M415-Red
245939 24039 10 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
245983 24041 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
245516 23014 12 79.000 A 0.000 A M315 50.00 0.00 0 0.00 M315-Seafoam
245940 24039 12 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
245517 23014 14 79.000 A 0.000 A M803 50.00 0.00 0 0.00 M803-Dark Grey
245941 24039 14 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
215716 21970 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
223758 22644 15 0.000 A 0.000 A 3500K 0.00 0.00 0 0.00 3500K - Bright White
229898 23015 15 5.000 A 0.000 A TGG 0.00 0.00 0 1.29 Heavy Duty Guard
230605 23091 15 33.000 A 0.000 A WH 0.00 0.00 0 0.00 Warehouse Shade
233111 23295 15 33.000 A 0.000 A WH 0.00 0.00 0 0.00 Warehouse Shade
242977 23070 15 39.000 A 0.000 A 39.00 0.00 0 0.00 LED Amber ST19 - 31-4.5FSST19DIM/820/A
245984 24041 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
245518 23014 16 79.000 A 0.000 A M210 50.00 0.00 0 0.00 M210-Cream
245942 24039 16 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
215738 21970 18 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
246006 24041 18 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
215731 21970 19 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
245999 24041 19 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
223759 22644 20 0.000 A 0.000 A 4000K 0.00 0.00 0 0.00 4000K - Cool White
230493 23070 20 42.000 A 0.000 A 42.00 0.00 0 0.00 LED Smoky ST19 - 31-4.5FSST19DIM/840/S
237036 21970 21 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
246008 24041 21 0.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237037 21970 22 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
246009 24041 22 0.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
215717 21970 24 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
229865 23014 24 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
245985 24041 24 0.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
242135 21970 25 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
246015 24041 25 0.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
229866 23014 26 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
241141 21970 26 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
246010 24041 26 0.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215718 21970 28 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
229867 23014 28 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
229900 23016 28 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
245986 24041 28 0.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
215719 21970 30 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
229868 23014 30 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
229901 23016 30 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
245987 24041 30 0.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
229890 23014 32 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
229902 23016 32 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
229883 23014 34 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
229903 23016 34 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
215720 21970 35 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
245988 24041 35 0.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
229904 23016 36 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
237072 23014 36 18.000 A 0.000 A 106 0.00 0.00 0 4.50 106-Matte Black
229905 23016 38 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
237073 23014 38 18.000 A 0.000 A 206 0.00 0.00 0 4.50 206-Matte White
215721 21970 40 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
229869 23014 40 18.000 A 0.000 A 307 0.00 0.00 0 4.50 307-Emerald Green
237068 23016 40 11.000 A 0.000 A 106 0.00 0.00 0 2.75 106-Matte Black
245989 24041 40 0.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
237069 23016 42 11.000 A 0.000 A 206 0.00 0.00 0 2.75 206-Matte White
241473 23014 42 18.000 A 0.000 A 320 0.00 0.00 0 4.50 320-Fern Green
229870 23014 44 18.000 A 0.000 A 370 0.00 0.00 0 4.50 370-Mint
229906 23016 44 11.000 A 0.000 A 307 0.00 0.00 0 2.75 307-Emerald Green
215722 21970 45 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
242159 23016 45 11.000 A 0.000 A 311 0.00 0.00 0 2.75 311-Jadite
245990 24041 45 0.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
229871 23014 46 18.000 A 0.000 A 380 0.00 0.00 0 4.50 380-Chartreuse
241478 23016 46 11.000 A 0.000 A 320 0.00 0.00 0 2.75 320-Fern Green
229872 23014 48 18.000 A 0.000 A 390 0.00 0.00 0 4.50 390-Teal
229907 23016 48 11.000 A 0.000 A 370 0.00 0.00 0 2.75 370-Mint
241142 21970 48 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
246011 24041 48 0.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
215723 21970 50 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
229873 23014 50 18.000 A 0.000 A 400 0.00 0.00 0 4.50 400-Barn Red
229908 23016 50 11.000 A 0.000 A 380 0.00 0.00 0 2.75 380-Chartreuse
245991 24041 50 0.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
229874 23014 52 18.000 A 0.000 A 420 0.00 0.00 0 4.50 420-Orange
229909 23016 52 11.000 A 0.000 A 390 0.00 0.00 0 2.75 390-Teal
229910 23016 54 11.000 A 0.000 A 400 0.00 0.00 0 2.75 400-Barn Red
241474 23014 54 18.000 A 0.000 A 430 0.00 0.00 0 4.50 430-Soft Clay
215724 21970 55 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
245992 24041 55 0.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
229875 23014 56 18.000 A 0.000 A 470 0.00 0.00 0 4.50 470-Watermelon
229911 23016 56 11.000 A 0.000 A 420 0.00 0.00 0 2.75 420-Orange
229876 23014 58 18.000 A 0.000 A 480 0.00 0.00 0 4.50 480-Blush Pink
241479 23016 58 11.000 A 0.000 A 430 0.00 0.00 0 2.75 430-Soft Clay
215725 21970 60 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
229877 23014 60 18.000 A 0.000 A 490 0.00 0.00 0 4.50 490-Magenta
229912 23016 60 11.000 A 0.000 A 470 0.00 0.00 0 2.75 470-Watermelon
245993 24041 60 0.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
215726 21970 65 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
229878 23014 65 18.000 A 0.000 A 495 0.00 0.00 0 4.50 495-Sherbet Orange
229913 23016 65 11.000 A 0.000 A 480 0.00 0.00 0 2.75 480-Blush Pink
245994 24041 65 0.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
215727 21970 70 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
229879 23014 70 18.000 A 0.000 A 500 0.00 0.00 0 4.50 500-Buttery Yellow
229914 23016 70 11.000 A 0.000 A 490 0.00 0.00 0 2.75 490-Magenta
245995 24041 70 0.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
215728 21970 75 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
229880 23014 75 18.000 A 0.000 A 570 0.00 0.00 0 4.50 570-Sunflower
229915 23016 75 11.000 A 0.000 A 495 0.00 0.00 0 2.75 495-Sherbet Orange
245996 24041 75 0.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
215729 21970 80 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
229881 23014 80 18.000 A 0.000 A 600 0.00 0.00 0 4.50 600-Bronze
229916 23016 80 11.000 A 0.000 A 500 0.00 0.00 0 2.75 500-Buttery Yellow
245997 24041 80 0.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
215730 21970 85 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
229882 23014 85 18.000 A 0.000 A 601 0.00 0.00 0 4.50 601-Chocolate
229917 23016 85 11.000 A 0.000 A 570 0.00 0.00 0 2.75 570-Sunflower
245998 24041 85 0.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241475 23014 88 18.000 A 0.000 A 607 0.00 0.00 0 4.50 607-Taupe
246012 24041 88 0.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
229918 23016 90 11.000 A 0.000 A 600 0.00 0.00 0 2.75 600-Bronze
241143 21970 90 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
215732 21970 95 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
229884 23014 95 18.000 A 0.000 A 615 0.00 0.00 0 4.50 615-Oil-Rubbed Bronze
229919 23016 95 11.000 A 0.000 A 601 0.00 0.00 0 2.75 601-Chocolate
246000 24041 95 0.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241144 21970 98 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241476 23014 98 18.000 A 0.000 A 630 0.00 0.00 0 4.50 630-Beige
241480 23016 98 11.000 A 0.000 A 607 0.00 0.00 0 2.75 607-Taupe
246013 24041 98 0.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
215733 21970 100 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
229885 23014 100 18.000 A 0.000 A 700 0.00 0.00 0 4.50 700-Royal Blue
229920 23016 100 11.000 A 0.000 A 615 0.00 0.00 0 2.75 615-Oil-Rubbed Bronze
246001 24041 100 0.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
241481 23016 103 11.000 A 0.000 A 630 0.00 0.00 0 2.75 630-Beige
215734 21970 105 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
229886 23014 105 18.000 A 0.000 A 705 0.00 0.00 0 4.50 705-Navy
229921 23016 105 11.000 A 0.000 A 700 0.00 0.00 0 2.75 700-Royal Blue
246002 24041 105 0.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
246016 24041 107 0.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
246017 24041 109 0.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
215735 21970 110 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
229887 23014 110 18.000 A 0.000 A 790 0.00 0.00 0 4.50 790-Lavender
229922 23016 110 11.000 A 0.000 A 705 0.00 0.00 0 2.75 705-Navy
246003 24041 110 0.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
242160 23016 111 11.000 A 0.000 A 710 0.00 0.00 0 2.75 710-Cobalt Blue
242136 21970 112 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242161 23016 112 11.000 A 0.000 A 715 0.00 0.00 0 2.75 715-Delphite Blue
242137 21970 113 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
215736 21970 115 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
229888 23014 115 18.000 A 0.000 A 800 0.00 0.00 0 4.50 800-Industrial Grey
229923 23016 115 11.000 A 0.000 A 790 0.00 0.00 0 2.75 790-Lavender
246004 24041 115 0.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
215737 21970 120 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
229889 23014 120 18.000 A 0.000 A 805 0.00 0.00 0 4.50 805-Charcoal Granite
229924 23016 120 11.000 A 0.000 A 800 0.00 0.00 0 2.75 800-Industrial Grey
246005 24041 120 0.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
246018 24041 122 0.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241477 23014 123 18.000 A 0.000 A 815 0.00 0.00 0 4.50 815-Light Grey
242138 21970 123 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
246014 24041 123 0.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
229925 23016 125 11.000 A 0.000 A 805 0.00 0.00 0 2.75 805-Charcoal Granite
241145 21970 125 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242162 23016 126 11.000 A 0.000 A 810 0.00 0.00 0 2.75 810-Graphite
242163 23014 126 18.000 A 0.000 A 311 0.00 0.00 0 4.50 311-Jadite
241482 23016 128 11.000 A 0.000 A 815 0.00 0.00 0 2.75 815-Light Grey
242164 23014 128 18.000 A 0.000 A 710 0.00 0.00 0 4.50 710-Cobalt Blue
242165 23014 130 18.000 A 0.000 A 715 0.00 0.00 0 4.50 715-Delphite Blue
242166 23014 132 18.000 A 0.000 A 810 0.00 0.00 0 4.50 810-Graphite