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 (
    22192, 23283, 23281, 23246, 23477, 23478, 
    23479, 23247, 23251, 23250, 23249, 
    23254, 23255, 23256, 23257, 23229, 
    23480, 23481, 22397
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00304

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": 298,
          "filtered": 100,
          "index_condition": "a.option_id in (22192,23283,23281,23246,23477,23478,23479,23247,23251,23250,23249,23254,23255,23256,23257,23229,23480,23481,22397) 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
218822 22192 0 0.000 A 0.000 A unselected 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
232268 23229 0 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
232597 23246 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
232605 23247 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
232621 23249 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
232632 23250 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
232643 23251 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
232712 23254 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
232725 23255 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
232738 23256 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
232764 23257 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
233043 23281 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
233047 23283 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
235995 23477 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
236021 23478 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
236048 23479 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
236062 23480 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
236088 23481 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
218823 22192 1 0.000 A 0.000 A 0.00 0.00 0 0.00 Standard Bulb E26/GU24
232599 23247 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
232613 23249 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
232624 23250 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
232635 23251 3 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
232686 23254 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
232739 23257 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
235996 23478 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
236022 23479 3 0.000 A 0.000 A 0.00 0.00 23246 0.00 Same as Shade
236063 23481 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
244670 23246 3 79.000 A 0.000 A M103 50.00 0.00 0 0.00 M103-Black
218824 22192 5 0.000 A 0.000 A 0.00 0.00 0 0.00 Integrated LED
221147 22397 5 0.000 A 0.000 A E26 0.00 0.00 0 0.00 Standard Incandescent
232269 23229 5 382.000 A 0.000 A PMDBSP8 0.00 0.00 0 0.00 8' Smooth Pole
232614 23249 5 20.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
232625 23250 5 20.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
232636 23251 5 20.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
232687 23254 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
232740 23257 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
233041 23281 5 0.000 A 0.000 A WHA14 0.00 0.00 0 0.00 14" Shade
233048 23283 5 0.000 A 0.000 A PMD 0.00 0.00 0 0.00 Double
235981 23477 5 0.000 A 0.000 A 0.00 0.00 23246 0.00 Same as Shade
235997 23478 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
236023 23479 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
236064 23481 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
244671 23246 5 79.000 A 0.000 A M200 50.00 0.00 0 0.00 M200-White
244678 23255 5 11.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
244686 23256 5 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
244694 23480 5 11.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
218825 22192 10 0.000 A 0.000 A 0.00 0.00 0 0.00 Nautical LED
221148 22397 10 27.000 A 0.000 A GU24 0.00 0.00 0 1.45 GU24
232270 23229 10 411.000 A 0.000 A PMDBFP8 0.00 0.00 0 0.00 8' Fluted Pole
232601 23247 10 97.000 A 0.000 A WC 0.00 0.00 0 0.00 Wire Cage
232615 23249 10 20.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
232626 23250 10 20.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
232637 23251 10 20.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
232688 23254 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
232741 23257 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
233042 23281 10 13.000 A 0.000 A WHA16 0.00 0.00 0 0.00 16" Shade
233049 23283 10 146.000 A 0.000 A PMDD 0.00 0.00 0 0.00 Double Decorative
235998 23478 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
236024 23479 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
236065 23481 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
244672 23246 10 79.000 A 0.000 A M305 50.00 0.00 0 0.00 M305-Forest Green
244679 23255 10 11.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
244687 23256 10 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
244695 23480 10 11.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
244886 23477 10 11.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
232602 23247 15 194.000 A 0.000 A WGG 0.00 0.00 0 0.00 Wire Guard & Glass
232689 23254 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
232742 23257 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
235999 23478 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
236025 23479 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
236066 23481 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
244673 23246 15 79.000 A 0.000 A M603 50.00 0.00 0 0.00 M603-Brown
244680 23255 15 11.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
244688 23256 15 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
244696 23480 15 11.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
244887 23477 15 11.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
232603 23247 20 194.000 A 0.000 A CGG 0.00 0.00 0 0.00 Cast Guard & Glass
232690 23254 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
232743 23257 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
236000 23478 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
236026 23479 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
236067 23481 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
244674 23246 20 79.000 A 0.000 A M415 50.00 0.00 0 0.00 M415-Red
244681 23255 20 11.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
244689 23256 20 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
244697 23480 20 11.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
244888 23477 20 11.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
232604 23247 25 194.000 A 0.000 A TGG 0.00 0.00 0 0.00 Heavy Duty Guard & Glass
232691 23254 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
232744 23257 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
236027 23479 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
244675 23246 25 79.000 A 0.000 A M315 50.00 0.00 0 0.00 M315-Seafoam
244682 23255 25 11.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
244690 23256 25 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
244698 23480 25 11.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
244889 23477 25 11.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
241286 23254 26 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
241288 23257 26 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
241287 23254 27 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
241289 23257 27 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
232692 23254 30 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
232745 23257 30 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
236002 23478 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
236029 23479 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
236069 23481 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
244676 23246 30 79.000 A 0.000 A M803 50.00 0.00 0 0.00 M803-Dark Grey
244683 23255 30 11.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
244691 23256 30 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
244699 23480 30 11.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
244890 23477 30 11.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
244677 23246 31 79.000 A 0.000 A M210 50.00 0.00 0 0.00 M210-Cream
237020 23479 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237022 23478 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237024 23481 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
245236 23254 32 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
245240 23257 32 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
237021 23479 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237023 23478 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237025 23481 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
241276 23254 33 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241281 23257 33 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
232693 23254 35 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
232746 23257 35 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
236003 23478 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
236030 23479 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
236070 23481 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
244684 23255 35 11.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
244692 23256 35 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
244700 23480 35 11.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
244891 23477 35 11.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
241866 23478 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241872 23479 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241879 23481 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
232694 23254 40 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
232747 23257 40 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
236004 23478 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
236031 23479 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
236071 23481 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
244685 23255 40 11.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
244693 23256 40 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
244701 23480 40 11.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
244892 23477 40 11.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
232695 23254 45 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
232748 23257 45 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
236005 23478 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
236032 23479 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
236072 23481 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
244893 23477 45 11.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
232696 23254 50 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
232749 23257 50 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
236006 23478 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
236033 23479 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
236073 23481 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
232567 23246 55 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
232697 23254 55 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
232750 23257 55 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
236007 23478 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
236034 23479 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
236074 23481 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
241277 23254 58 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241282 23257 58 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
232568 23246 60 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
232698 23254 60 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
232751 23257 60 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
236008 23478 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
236035 23479 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
236075 23481 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
241867 23478 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241873 23479 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241880 23481 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
232569 23246 65 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
232699 23254 65 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
232752 23257 65 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
236009 23478 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
236036 23479 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
236076 23481 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
232570 23246 70 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
232700 23254 70 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
232753 23257 70 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
236010 23478 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
236037 23479 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
236077 23481 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
232571 23246 75 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
232701 23254 75 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
232754 23257 75 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
236011 23478 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
236038 23479 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
236078 23481 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
232572 23246 80 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
232702 23254 80 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
232755 23257 80 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
236012 23478 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
236039 23479 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
236079 23481 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
237018 23246 82 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237019 23246 83 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
232573 23246 85 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
232703 23254 85 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
232756 23257 85 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
236013 23478 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
236040 23479 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
236080 23481 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
245232 23246 86 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
241271 23246 88 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
232574 23246 90 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
232704 23254 90 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
232757 23257 90 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
236014 23478 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
236041 23479 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
236081 23481 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
232575 23246 95 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
232705 23254 95 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
232758 23257 95 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
236015 23478 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
236042 23479 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
236082 23481 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
241278 23254 98 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241283 23257 98 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
232576 23246 100 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
232706 23254 100 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
232759 23257 100 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
236016 23478 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
236043 23479 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
236083 23481 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241279 23254 102 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241868 23478 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241874 23479 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241881 23481 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241284 23257 104 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
232577 23246 105 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
232707 23254 105 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
232760 23257 105 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
236017 23478 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
236044 23479 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
236084 23481 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241869 23478 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241875 23479 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241882 23481 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
232578 23246 110 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
232708 23254 110 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
232761 23257 110 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
236018 23478 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
236045 23479 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
236085 23481 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
245237 23254 112 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245241 23257 112 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
232765 23257 113 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
241272 23246 113 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
245242 23257 113 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
245238 23254 114 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
232579 23246 115 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
232709 23254 115 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
232762 23257 115 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
236019 23478 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
236046 23479 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
236086 23481 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
241871 23478 118 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
241877 23479 118 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
241878 23481 118 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
232580 23246 120 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
232710 23254 120 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
232763 23257 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
236020 23478 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
236047 23479 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
236087 23481 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
245243 23257 122 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241285 23257 123 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241870 23478 123 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241876 23479 123 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241883 23481 123 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
232581 23246 125 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
232711 23254 125 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
245239 23254 127 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241280 23254 128 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
232582 23246 130 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
232583 23246 135 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
232584 23246 140 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
232585 23246 145 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
232586 23246 150 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241273 23246 153 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
232587 23246 155 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241274 23246 158 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
232588 23246 160 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
232589 23246 165 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
245233 23246 166 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245234 23246 167 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
232598 23246 168 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
232590 23246 170 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
232591 23246 175 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
245235 23246 176 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
232592 23246 180 160.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
241275 23246 180 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
232593 23246 185 200.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
232594 23246 190 250.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
232595 23246 195 210.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
232596 23246 200 250.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass