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 (
    21970, 22746, 22224, 23570, 22723, 22724, 
    22725, 22727, 22728, 23571, 22395, 
    22825, 23716, 22826, 22794, 22795, 
    22796, 22797, 22798, 23052, 23074, 
    23043, 23015, 24038, 24040, 23027, 
    23028, 23029, 23116, 22644, 22394
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00456

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": 395,
          "filtered": 100,
          "index_condition": "a.option_id in (21970,22746,22224,23570,22723,22724,22725,22727,22728,23571,22395,22825,23716,22826,22794,22795,22796,22797,22798,23052,23074,23043,23015,24038,24040,23027,23028,23029,23116,22644,22394) 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
220212 22224 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
221133 22394 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
221140 22395 0 0.000 A 0.000 A unselected 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
225255 22723 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
225266 22724 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
225277 22725 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
225335 22727 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
225366 22728 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
225700 22746 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
226434 22794 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
226439 22795 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
226444 22796 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
226449 22797 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
226485 22798 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
226883 22825 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
226888 22826 0 0.000 A 0.000 A skip 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
230049 23027 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230060 23028 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230071 23029 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230215 23043 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230335 23052 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
230513 23074 0 0.000 A 0.000 A unselected 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
237792 23570 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
237823 23571 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
239298 23716 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
245914 24038 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
245969 24040 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
245591 23052 2 79.000 A 0.000 A M103 50.00 0.00 0 0.00 M103-Black
245926 24038 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
225245 22723 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
225256 22724 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
225267 22725 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
225305 22727 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
225336 22728 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
226438 22794 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
226443 22795 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
226448 22796 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
226453 22797 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
229896 23015 3 0.000 A 0.000 A WGG 0.00 0.00 0 0.00 Wire Guard
230041 23027 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
230052 23028 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
230063 23029 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
237786 23570 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
237793 23571 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
239263 23716 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
240513 22826 3 0.000 A 0.000 A ST506 0.00 0.00 0 0.00 6" Stem
245943 24040 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
245592 23052 4 79.000 A 0.000 A M200 50.00 0.00 0 0.00 M200-White
245927 24038 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
219067 22224 5 0.000 A 0.000 A SC 0.00 0.00 0 0.00 Standard Canopy
221134 22394 5 0.000 A 0.000 A ST506 0.00 0.00 0 0.00 6" Stem - ½ Diameter
221141 22395 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
225246 22723 5 40.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
225257 22724 5 40.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
225268 22725 5 40.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
225306 22727 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
225337 22728 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
226435 22794 5 30.000 A 0.000 A PB1 0.00 0.00 0 0.00 PB1 - Single Painted Band
226440 22795 5 30.000 A 0.000 A PB1 0.00 0.00 0 0.00 PB1 - Single Painted Band
226445 22796 5 30.000 A 0.000 A PB1 0.00 0.00 0 0.00 PB1 - Single Painted Band
226450 22797 5 30.000 A 0.000 A PB1 0.00 0.00 0 0.00 PB1 - Single Painted Band
226455 22798 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
226884 22825 5 0.000 A 0.000 A SCH10 0.00 0.00 0 0.00 Small Opaque Glass
226889 22826 5 0.000 A 0.000 A ST512 0.00 0.00 0 0.00 12" Stem
229897 23015 5 5.000 A 0.000 A CGG 0.00 0.00 0 1.29 Cast Guard
230042 23027 5 40.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
230053 23028 5 40.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
230064 23029 5 40.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
230216 23043 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 No Shade
230510 23074 5 0.000 A 0.000 A SC 0.00 0.00 0 0.00 Standard Canopy
230827 23116 5 0.000 A 0.000 A LED16.8 0.00 0.00 0 0.00 16.8W LED - 1600 Lumen
237787 23570 5 348.000 A 0.000 A ACR 0.00 0.00 0 {"215104":"85.00","215105":"95.00","215106":"140.00","215107":"165.00","217563":"65.00","217565":"85.00","217566":"95.00","217689":"95.00","217690":"140.00","217876":"85.00","218827":"65.00","218916":"85.00","218917":"95.00","219017":"85.00","219018":"95.00"} 0.00 Acrylic Diffuser
237794 23571 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
239264 23716 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
245944 24040 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
245593 23052 6 79.000 A 0.000 A M305 50.00 0.00 0 0.00 M305-Forest Green
245928 24038 6 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
245594 23052 8 79.000 A 0.000 A M603 50.00 0.00 0 0.00 M603-Brown
245929 24038 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
219068 22224 10 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
221135 22394 10 3.000 A 0.000 A ST512 0.00 0.00 0 0.00 12" Stem - ½ Diameter
221142 22395 10 53.000 A 0.000 A GU24 0.00 0.00 0 0.00 GU24
223757 22644 10 0.000 A 0.000 A 3000K 0.00 0.00 0 0.00 3000K - Neutral White
225247 22723 10 40.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
225258 22724 10 40.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
225269 22725 10 40.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
225307 22727 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
225338 22728 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
225702 22746 10 0.000 A 0.000 A ST512 0.00 0.00 0 0.00 12" Stem - ½ Diameter
226436 22794 10 30.000 A 0.000 A PB2 0.00 0.00 0 0.00 PB2 - Double Painted Band
226441 22795 10 30.000 A 0.000 A PB2 0.00 0.00 0 0.00 PB2 - Double Painted Band
226446 22796 10 30.000 A 0.000 A PB2 0.00 0.00 0 0.00 PB2 - Double Painted Band
226451 22797 10 30.000 A 0.000 A PB2 0.00 0.00 0 0.00 PB2 - Double Painted Band
226885 22825 10 141.000 A 0.000 A SCH14 0.00 0.00 0 0.00 Large Opaque Glass
226890 22826 10 7.000 A 0.000 A ST518 0.00 0.00 0 0.00 18" Stem
230043 23027 10 40.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
230054 23028 10 40.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
230065 23029 10 40.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
230217 23043 10 44.000 A 0.000 A FS 0.00 0.00 0 0.00 Flared Shade
230511 23074 10 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
237788 23570 10 194.000 A 0.000 A WC 0.00 0.00 0 {"215106":"48.00","215107":"53.00"} 0.00 Wire Cage
237795 23571 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
239265 23716 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
245595 23052 10 79.000 A 0.000 A M415 50.00 0.00 0 0.00 M415-Red
245930 24038 10 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
245945 24040 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
245596 23052 12 79.000 A 0.000 A M315 50.00 0.00 0 0.00 M315-Seafoam
245931 24038 12 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
245597 23052 14 79.000 A 0.000 A M803 50.00 0.00 0 0.00 M803-Dark Grey
245932 24038 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
219069 22224 15 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
221136 22394 15 5.000 A 0.000 A ST518 0.00 0.00 0 0.00 18" Stem - ½ Diameter
223758 22644 15 0.000 A 0.000 A 3500K 0.00 0.00 0 0.00 3500K - Bright White
225308 22727 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
225339 22728 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
225703 22746 15 5.000 A 0.000 A ST518 0.00 0.00 0 0.00 18" Stem - ½ Diameter
226437 22794 15 30.000 A 0.000 A PB3 0.00 0.00 0 0.00 PB3 - Triple Painted Band
226442 22795 15 30.000 A 0.000 A PB3 0.00 0.00 0 0.00 PB3 - Triple Painted Band
226447 22796 15 30.000 A 0.000 A PB3 0.00 0.00 0 0.00 PB3 - Triple Painted Band
226452 22797 15 30.000 A 0.000 A PB3 0.00 0.00 0 0.00 PB3 - Triple Painted Band
226457 22798 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
226886 22825 15 0.000 A 0.000 A SCHCL10 0.00 0.00 0 0.00 Small Clear Glass
226891 22826 15 10.000 A 0.000 A ST524 0.00 0.00 0 0.00 24" Stem
229898 23015 15 5.000 A 0.000 A TGG 0.00 0.00 0 1.29 Heavy Duty Guard
230218 23043 15 66.000 A 0.000 A WH 0.00 0.00 0 0.00 Warehouse Shade
230512 23074 15 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
237789 23570 15 388.000 A 0.000 A WGG 0.00 0.00 0 0.00 Wire Guard & Glass
237796 23571 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
239266 23716 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
245946 24040 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
245598 23052 16 79.000 A 0.000 A M210 50.00 0.00 0 0.00 M210-Cream
245933 24038 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
245968 24040 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
245961 24040 19 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
221137 22394 20 7.000 A 0.000 A ST524 0.00 0.00 0 0.00 24" Stem - ½ Diameter
223759 22644 20 0.000 A 0.000 A 4000K 0.00 0.00 0 0.00 4000K - Cool White
225309 22727 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
225340 22728 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
225704 22746 20 7.000 A 0.000 A ST524 0.00 0.00 0 0.00 24" Stem - ½ Diameter
226887 22825 20 141.000 A 0.000 A SCHCL14 0.00 0.00 0 0.00 Large Clear Glass
226892 22826 20 16.000 A 0.000 A ST536 0.00 0.00 0 0.00 36" Stem
237790 23570 20 388.000 A 0.000 A CGG 0.00 0.00 0 0.00 Cast Guard & Glass
237797 23571 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
239267 23716 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
237036 21970 21 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
245970 24040 21 0.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
230305 23052 22 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
237037 21970 22 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
245971 24040 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
230306 23052 24 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
245947 24040 24 0.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
221138 22394 25 12.000 A 0.000 A ST536 0.00 0.00 0 0.00 36" Stem - ½ Diameter
225310 22727 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
225341 22728 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
225705 22746 25 12.000 A 0.000 A ST536 0.00 0.00 0 0.00 36" Stem - ½ Diameter
226893 22826 25 22.000 A 0.000 A ST548 0.00 0.00 0 0.00 48" Stem
237791 23570 25 388.000 A 0.000 A TGG 0.00 0.00 0 0.00 Heavy Duty Guard & Glass
237798 23571 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
239268 23716 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
242135 21970 25 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
245977 24040 25 0.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
230307 23052 26 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
241141 21970 26 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
245972 24040 26 0.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
237186 22727 27 44.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237188 22728 27 44.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237824 23571 27 44.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
239299 23716 27 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
215718 21970 28 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
230308 23052 28 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
237187 22727 28 44.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237189 22728 28 44.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237825 23571 28 44.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
239300 23716 28 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
245948 24040 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
221139 22394 30 16.000 A 0.000 A ST548 0.00 0.00 0 0.00 48" Stem - ½ Diameter
225311 22727 30 44.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
225342 22728 30 44.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
225706 22746 30 16.000 A 0.000 A ST548 0.00 0.00 0 0.00 48" Stem - ½ Diameter
230330 23052 30 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
237799 23571 30 44.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
239269 23716 30 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
245949 24040 30 0.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
225331 22727 32 44.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Seafoam
225362 22728 32 44.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Seafoam
230323 23052 32 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
237819 23571 32 44.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Seafoam
241376 23716 33 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241954 22727 33 44.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241959 22728 33 44.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241964 23571 33 44.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
237082 23052 34 18.000 A 0.000 A 106 0.00 0.00 0 4.50 106-Matte Black
215720 21970 35 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
225312 22727 35 44.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
225343 22728 35 44.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
237800 23571 35 44.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
239270 23716 35 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
245950 24040 35 0.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
237083 23052 36 18.000 A 0.000 A 206 0.00 0.00 0 4.50 206-Matte White
230309 23052 38 18.000 A 0.000 A 307 0.00 0.00 0 4.50 307-Emerald Green
215721 21970 40 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
225313 22727 40 44.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
225344 22728 40 44.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
226462 22798 40 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
237801 23571 40 44.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
239271 23716 40 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
242155 23052 40 18.000 A 0.000 A 311 0.00 0.00 0 4.50 311-Jadite
245951 24040 40 0.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
241585 23052 42 18.000 A 0.000 A 320 0.00 0.00 0 4.50 320-Fern Green
230310 23052 44 18.000 A 0.000 A 370 0.00 0.00 0 4.50 370-Mint
215722 21970 45 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
225314 22727 45 44.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
225345 22728 45 44.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
237802 23571 45 44.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
239272 23716 45 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
245952 24040 45 0.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
230311 23052 46 18.000 A 0.000 A 380 0.00 0.00 0 4.50 380-Chartreuse
230312 23052 48 18.000 A 0.000 A 390 0.00 0.00 0 4.50 390-Teal
241142 21970 48 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
245973 24040 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
225315 22727 50 44.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
225346 22728 50 44.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
226481 22798 50 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
230313 23052 50 18.000 A 0.000 A 400 0.00 0.00 0 4.50 400-Barn Red
237803 23571 50 44.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
239273 23716 50 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
245953 24040 50 0.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
230314 23052 52 18.000 A 0.000 A 420 0.00 0.00 0 4.50 420-Orange
244281 22798 53 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241586 23052 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
225316 22727 55 44.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
225347 22728 55 44.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
226465 22798 55 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
237804 23571 55 44.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
239274 23716 55 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
245954 24040 55 0.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
230315 23052 56 18.000 A 0.000 A 470 0.00 0.00 0 4.50 470-Watermelon
230316 23052 58 18.000 A 0.000 A 480 0.00 0.00 0 4.50 480-Blush Pink
241377 23716 58 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241955 22727 58 44.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241960 22728 58 44.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241965 23571 58 44.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
215725 21970 60 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
225317 22727 60 44.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
225348 22728 60 44.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
226466 22798 60 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
230317 23052 60 18.000 A 0.000 A 490 0.00 0.00 0 4.50 490-Magenta
237805 23571 60 44.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
239275 23716 60 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
245955 24040 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
225318 22727 65 44.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
225349 22728 65 44.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
230318 23052 65 18.000 A 0.000 A 495 0.00 0.00 0 4.50 495-Sherbet Orange
237806 23571 65 44.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
239276 23716 65 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
244282 22798 65 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
245956 24040 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
225319 22727 70 44.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
225350 22728 70 44.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
230319 23052 70 18.000 A 0.000 A 500 0.00 0.00 0 4.50 500-Buttery Yellow
237807 23571 70 44.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
239277 23716 70 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
239948 22798 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
245957 24040 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
225320 22727 75 44.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
225351 22728 75 44.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
230320 23052 75 18.000 A 0.000 A 570 0.00 0.00 0 4.50 570-Sunflower
237808 23571 75 44.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
239278 23716 75 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
245958 24040 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
225321 22727 80 44.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
225352 22728 80 44.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
226470 22798 80 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
230321 23052 80 18.000 A 0.000 A 600 0.00 0.00 0 4.50 600-Bronze
237809 23571 80 44.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
239279 23716 80 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
245959 24040 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
225322 22727 85 44.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
225353 22728 85 44.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
230322 23052 85 18.000 A 0.000 A 601 0.00 0.00 0 4.50 601-Chocolate
237810 23571 85 44.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
239280 23716 85 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
245960 24040 85 0.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241587 23052 88 18.000 A 0.000 A 607 0.00 0.00 0 4.50 607-Taupe
245974 24040 88 0.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
225323 22727 90 44.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
225354 22728 90 44.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
226472 22798 90 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
237811 23571 90 44.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
239281 23716 90 18.000 A 0.000 A 600 0.00 0.00 0 0.00 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
225324 22727 95 44.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
225355 22728 95 44.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
230324 23052 95 18.000 A 0.000 A 615 0.00 0.00 0 4.50 615-Oil-Rubbed Bronze
237812 23571 95 44.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
239282 23716 95 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
245962 24040 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
241378 23716 98 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241588 23052 98 18.000 A 0.000 A 630 0.00 0.00 0 4.50 630-Beige
241956 22727 98 44.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241961 22728 98 44.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241966 23571 98 44.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
245975 24040 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
225325 22727 100 44.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
225356 22728 100 44.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
226474 22798 100 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
230325 23052 100 18.000 A 0.000 A 700 0.00 0.00 0 4.50 700-Royal Blue
237813 23571 100 44.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
239283 23716 100 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
245963 24040 100 0.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
241379 23716 103 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241957 22727 103 44.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241962 22728 103 44.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241967 23571 103 44.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
215734 21970 105 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
225326 22727 105 44.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
225357 22728 105 44.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
230326 23052 105 18.000 A 0.000 A 705 0.00 0.00 0 4.50 705-Navy
237814 23571 105 44.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
239284 23716 105 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
245964 24040 105 0.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
242156 23052 106 18.000 A 0.000 A 710 0.00 0.00 0 4.50 710-Cobalt Blue
242157 23052 107 18.000 A 0.000 A 715 0.00 0.00 0 4.50 715-Delphite Blue
245978 24040 107 0.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245979 24040 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
225327 22727 110 44.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
225358 22728 110 44.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
230327 23052 110 18.000 A 0.000 A 790 0.00 0.00 0 4.50 790-Lavender
237815 23571 110 44.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
239285 23716 110 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
245965 24040 110 0.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
225364 22728 112 44.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Sky Blue
242136 21970 112 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
225333 22727 113 44.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Sky Blue
237821 23571 113 44.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Sky 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
225328 22727 115 44.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
225359 22728 115 44.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
226477 22798 115 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
230328 23052 115 18.000 A 0.000 A 800 0.00 0.00 0 4.50 800-Industrial Grey
237816 23571 115 44.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
239286 23716 115 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
245966 24040 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
225329 22727 120 44.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
225360 22728 120 44.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
226478 22798 120 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
230329 23052 120 18.000 A 0.000 A 805 0.00 0.00 0 4.50 805-Charcoal Granite
237817 23571 120 44.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
239287 23716 120 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
245967 24040 120 0.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
242158 23052 122 18.000 A 0.000 A 810 0.00 0.00 0 4.50 810-Graphite
245980 24040 122 0.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
226483 22798 123 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite
241589 23052 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
245976 24040 123 0.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
225330 22727 125 44.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
225361 22728 125 44.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
237818 23571 125 44.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
239288 23716 125 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
241145 21970 125 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241380 23716 128 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241958 22727 128 44.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241963 22728 128 44.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241968 23571 128 44.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242191 23716 130 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
242192 23716 132 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242193 23716 134 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
242194 23716 136 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite