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 (
    23152, 22394, 22224, 23154, 21941, 23052, 
    22746, 23074, 23015, 23016, 23027, 
    23028, 23029, 23116, 22644, 22827, 
    22823, 22828, 23562, 23717, 22794, 
    22795, 22796, 22797, 22798, 22396, 
    22825, 23716, 22826, 22395
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00539

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": 367,
          "filtered": 100,
          "index_condition": "a.option_id in (23152,22394,22224,23154,21941,23052,22746,23074,23015,23016,23027,23028,23029,23116,22644,22827,22823,22828,23562,23717,22794,22795,22796,22797,22798,22396,22825,23716,22826,22395) 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
220212 22224 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
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
221143 22396 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
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
226866 22823 0 0.000 A 0.000 A skip 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
226894 22827 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
226899 22828 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
229930 23016 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
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
231294 23152 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
231363 23154 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
237730 23562 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
239304 23717 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
215376 21941 3 0.000 A 0.000 A E26 0.00 0.00 0 0.00 E26
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
226831 22823 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
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
231264 23152 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
239305 23717 3 0.000 A 0.000 A SC 0.00 0.00 0 0.00 Standard Canopy
240513 22826 3 0.000 A 0.000 A ST506 0.00 0.00 0 0.00 6" Stem
245592 23052 4 79.000 A 0.000 A M200 50.00 0.00 0 0.00 M200-White
215377 21941 5 14.000 A 0.000 A GU24 0.00 0.00 0 3.50 GU24
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
221144 22396 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
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
226832 22823 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured 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
226895 22827 5 0.000 A 0.000 A SCH10 0.00 0.00 0 0.00 Small Opaque Glass
226900 22828 5 0.000 A 0.000 A 18 0.00 0.00 0 0.00 (2) 18" Mounting Arms
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
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
231265 23152 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
231333 23154 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
237743 23562 5 0.000 A 0.000 A ST706 0.00 0.00 0 0.00 6" Stem
239264 23716 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
239301 23717 5 0.000 A 0.000 A SCDBCC 0.00 0.00 0 0.00 Standard Beehive Canopy
245593 23052 6 79.000 A 0.000 A M305 50.00 0.00 0 0.00 M305-Forest Green
237731 23562 8 0.000 A 0.000 A ST712 0.00 0.00 0 0.00 12" Stem
245594 23052 8 79.000 A 0.000 A M603 50.00 0.00 0 0.00 M603-Brown
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
221145 22396 10 40.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
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
226833 22823 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
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
226896 22827 10 106.000 A 0.000 A SCH14 0.00 0.00 0 0.00 Large Opaque Glass
226901 22828 10 36.000 A 0.000 A 24 0.00 0.00 0 0.00 (2) 24" Mounting Arms
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
230511 23074 10 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
231266 23152 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
231334 23154 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
237732 23562 10 7.000 A 0.000 A ST718 0.00 0.00 0 0.00 18" Stem
239265 23716 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
239302 23717 10 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
245595 23052 10 79.000 A 0.000 A M415 50.00 0.00 0 0.00 M415-Red
245596 23052 12 79.000 A 0.000 A M315 50.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
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
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
226834 22823 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
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
226897 22827 15 0.000 A 0.000 A SCHCL10 0.00 0.00 0 0.00 Small Clear Glass
229898 23015 15 5.000 A 0.000 A TGG 0.00 0.00 0 1.29 Heavy Duty Guard
230512 23074 15 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
231267 23152 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
231335 23154 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
237733 23562 15 10.000 A 0.000 A ST724 0.00 0.00 0 0.00 24" Stem
239266 23716 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
239303 23717 15 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
245598 23052 16 79.000 A 0.000 A M210 50.00 0.00 0 0.00 M210-Cream
231289 23152 18 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
231282 23152 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
225704 22746 20 7.000 A 0.000 A ST524 0.00 0.00 0 0.00 24" Stem - ½ Diameter
226835 22823 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
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
226898 22827 20 106.000 A 0.000 A SCHCL14 0.00 0.00 0 0.00 Large Clear Glass
231336 23154 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
237734 23562 20 16.000 A 0.000 A ST736 0.00 0.00 0 0.00 36" Stem
239267 23716 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
237130 23152 21 18.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
237131 23152 22 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
230306 23052 24 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
231268 23152 24 18.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
225705 22746 25 12.000 A 0.000 A ST536 0.00 0.00 0 0.00 36" Stem - ½ Diameter
226836 22823 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
226893 22826 25 22.000 A 0.000 A ST548 0.00 0.00 0 0.00 48" Stem
231337 23154 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
237735 23562 25 22.000 A 0.000 A ST748 0.00 0.00 0 0.00 48" Stem
239268 23716 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
242569 23152 25 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
230307 23052 26 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
237164 22823 27 18.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
229900 23016 28 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
230308 23052 28 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
231269 23152 28 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
237165 22823 28 18.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
221139 22394 30 16.000 A 0.000 A ST548 0.00 0.00 0 0.00 48" Stem - ½ Diameter
225706 22746 30 16.000 A 0.000 A ST548 0.00 0.00 0 0.00 48" Stem - ½ Diameter
226837 22823 30 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
229901 23016 30 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
230330 23052 30 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
231270 23152 30 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
231338 23154 30 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
239269 23716 30 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
229902 23016 32 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
230323 23052 32 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
241345 22823 33 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241376 23716 33 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
229903 23016 34 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
237082 23052 34 18.000 A 0.000 A 106 0.00 0.00 0 4.50 106-Matte Black
226838 22823 35 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
231271 23152 35 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
231339 23154 35 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
239270 23716 35 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
229904 23016 36 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
237083 23052 36 18.000 A 0.000 A 206 0.00 0.00 0 4.50 206-Matte White
237200 23154 37 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
229905 23016 38 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
230309 23052 38 18.000 A 0.000 A 307 0.00 0.00 0 4.50 307-Emerald Green
237201 23154 38 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
226462 22798 40 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
226839 22823 40 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
231272 23152 40 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
231340 23154 40 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
237068 23016 40 11.000 A 0.000 A 106 0.00 0.00 0 2.75 106-Matte Black
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
237069 23016 42 11.000 A 0.000 A 206 0.00 0.00 0 2.75 206-Matte White
241585 23052 42 18.000 A 0.000 A 320 0.00 0.00 0 4.50 320-Fern Green
242574 23154 43 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
229906 23016 44 11.000 A 0.000 A 307 0.00 0.00 0 2.75 307-Emerald Green
230310 23052 44 18.000 A 0.000 A 370 0.00 0.00 0 4.50 370-Mint
226840 22823 45 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
231273 23152 45 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
231341 23154 45 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
239272 23716 45 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
242159 23016 45 11.000 A 0.000 A 311 0.00 0.00 0 2.75 311-Jadite
230311 23052 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
229907 23016 48 11.000 A 0.000 A 370 0.00 0.00 0 2.75 370-Mint
230312 23052 48 18.000 A 0.000 A 390 0.00 0.00 0 4.50 390-Teal
242570 23152 48 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
226481 22798 50 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
226841 22823 50 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
229908 23016 50 11.000 A 0.000 A 380 0.00 0.00 0 2.75 380-Chartreuse
230313 23052 50 18.000 A 0.000 A 400 0.00 0.00 0 4.50 400-Barn Red
231274 23152 50 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
231342 23154 50 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
239273 23716 50 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
229909 23016 52 11.000 A 0.000 A 390 0.00 0.00 0 2.75 390-Teal
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
229910 23016 54 11.000 A 0.000 A 400 0.00 0.00 0 2.75 400-Barn Red
241586 23052 54 18.000 A 0.000 A 430 0.00 0.00 0 4.50 430-Soft Clay
226465 22798 55 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
226842 22823 55 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
231275 23152 55 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
231343 23154 55 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
239274 23716 55 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
229911 23016 56 11.000 A 0.000 A 420 0.00 0.00 0 2.75 420-Orange
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
241346 22823 58 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241377 23716 58 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241479 23016 58 11.000 A 0.000 A 430 0.00 0.00 0 2.75 430-Soft Clay
226466 22798 60 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
226843 22823 60 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
229912 23016 60 11.000 A 0.000 A 470 0.00 0.00 0 2.75 470-Watermelon
230317 23052 60 18.000 A 0.000 A 490 0.00 0.00 0 4.50 490-Magenta
231276 23152 60 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
231344 23154 60 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
239275 23716 60 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
226844 22823 65 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
229913 23016 65 11.000 A 0.000 A 480 0.00 0.00 0 2.75 480-Blush Pink
230318 23052 65 18.000 A 0.000 A 495 0.00 0.00 0 4.50 495-Sherbet Orange
231277 23152 65 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
231345 23154 65 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
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
242575 23154 68 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
226845 22823 70 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
229914 23016 70 11.000 A 0.000 A 490 0.00 0.00 0 2.75 490-Magenta
230319 23052 70 18.000 A 0.000 A 500 0.00 0.00 0 4.50 500-Buttery Yellow
231278 23152 70 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
231346 23154 70 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
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
226846 22823 75 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
229915 23016 75 11.000 A 0.000 A 495 0.00 0.00 0 2.75 495-Sherbet Orange
230320 23052 75 18.000 A 0.000 A 570 0.00 0.00 0 4.50 570-Sunflower
231279 23152 75 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
231347 23154 75 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
239278 23716 75 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
226470 22798 80 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
226847 22823 80 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
229916 23016 80 11.000 A 0.000 A 500 0.00 0.00 0 2.75 500-Buttery Yellow
230321 23052 80 18.000 A 0.000 A 600 0.00 0.00 0 4.50 600-Bronze
231280 23152 80 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
231348 23154 80 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
239279 23716 80 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
226848 22823 85 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
229917 23016 85 11.000 A 0.000 A 570 0.00 0.00 0 2.75 570-Sunflower
230322 23052 85 18.000 A 0.000 A 601 0.00 0.00 0 4.50 601-Chocolate
231281 23152 85 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
231349 23154 85 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
239280 23716 85 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
241587 23052 88 18.000 A 0.000 A 607 0.00 0.00 0 4.50 607-Taupe
242571 23152 88 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
226472 22798 90 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
226849 22823 90 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
229918 23016 90 11.000 A 0.000 A 600 0.00 0.00 0 2.75 600-Bronze
231350 23154 90 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
239281 23716 90 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
226850 22823 95 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
229919 23016 95 11.000 A 0.000 A 601 0.00 0.00 0 2.75 601-Chocolate
230324 23052 95 18.000 A 0.000 A 615 0.00 0.00 0 4.50 615-Oil-Rubbed Bronze
231283 23152 95 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
231351 23154 95 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
239282 23716 95 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241347 22823 98 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241378 23716 98 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241480 23016 98 11.000 A 0.000 A 607 0.00 0.00 0 2.75 607-Taupe
241588 23052 98 18.000 A 0.000 A 630 0.00 0.00 0 4.50 630-Beige
242572 23152 98 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
226474 22798 100 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
226851 22823 100 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
229920 23016 100 11.000 A 0.000 A 615 0.00 0.00 0 2.75 615-Oil-Rubbed Bronze
230325 23052 100 18.000 A 0.000 A 700 0.00 0.00 0 4.50 700-Royal Blue
231284 23152 100 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
231352 23154 100 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
239283 23716 100 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241348 22823 103 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241379 23716 103 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241481 23016 103 11.000 A 0.000 A 630 0.00 0.00 0 2.75 630-Beige
226852 22823 105 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
229921 23016 105 11.000 A 0.000 A 700 0.00 0.00 0 2.75 700-Royal Blue
230326 23052 105 18.000 A 0.000 A 705 0.00 0.00 0 4.50 705-Navy
231285 23152 105 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
231353 23154 105 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
239284 23716 105 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
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
242576 23154 108 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
226853 22823 110 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
229922 23016 110 11.000 A 0.000 A 705 0.00 0.00 0 2.75 705-Navy
230327 23052 110 18.000 A 0.000 A 790 0.00 0.00 0 4.50 790-Lavender
231286 23152 110 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
231354 23154 110 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
239285 23716 110 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
242160 23016 111 11.000 A 0.000 A 710 0.00 0.00 0 2.75 710-Cobalt Blue
242161 23016 112 11.000 A 0.000 A 715 0.00 0.00 0 2.75 715-Delphite Blue
242577 23154 113 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
226477 22798 115 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
226854 22823 115 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
229923 23016 115 11.000 A 0.000 A 790 0.00 0.00 0 2.75 790-Lavender
230328 23052 115 18.000 A 0.000 A 800 0.00 0.00 0 4.50 800-Industrial Grey
231287 23152 115 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
231355 23154 115 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
239286 23716 115 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
226478 22798 120 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
226855 22823 120 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
229924 23016 120 11.000 A 0.000 A 800 0.00 0.00 0 2.75 800-Industrial Grey
230329 23052 120 18.000 A 0.000 A 805 0.00 0.00 0 4.50 805-Charcoal Granite
231288 23152 120 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
231356 23154 120 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
239287 23716 120 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
242158 23052 122 18.000 A 0.000 A 810 0.00 0.00 0 4.50 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
242573 23152 123 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
226856 22823 125 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
229925 23016 125 11.000 A 0.000 A 805 0.00 0.00 0 2.75 805-Charcoal Granite
231357 23154 125 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
239288 23716 125 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
242162 23016 126 11.000 A 0.000 A 810 0.00 0.00 0 2.75 810-Graphite
241349 22823 128 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
241482 23016 128 11.000 A 0.000 A 815 0.00 0.00 0 2.75 815-Light Grey
231290 23152 130 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
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
231291 23152 135 29.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
231358 23154 135 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
242194 23716 136 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
242578 23154 138 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
231292 23152 140 29.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
231359 23154 140 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
231293 23152 145 29.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
231360 23154 145 17.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
226861 22823 150 220.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
231295 23152 150 50.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
231361 23154 150 17.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
226862 22823 155 249.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
231296 23152 155 66.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
231362 23154 155 17.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
226863 22823 160 249.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
231297 23152 160 83.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
226864 22823 165 249.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
231298 23152 165 66.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
226865 22823 170 278.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
231299 23152 170 99.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
242561 22823 172 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
242562 22823 174 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242563 22823 176 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
242564 22823 178 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite