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 (
    22057, 23426, 23427, 23428, 22254, 23435, 
    23436, 23140, 22644, 22645, 22380, 
    22367, 22347, 22349, 22348, 22365, 
    22356, 22355, 22357, 22358, 22359, 
    22360, 21941, 21947, 22352, 22366, 
    22350, 22351, 23116
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00414

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": 417,
          "filtered": 100,
          "index_condition": "a.option_id in (22057,23426,23427,23428,22254,23435,23436,23140,22644,22645,22380,22367,22347,22349,22348,22365,22356,22355,22357,22358,22359,22360,21941,21947,22352,22366,22350,22351,23116) 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
220115 22057 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
220172 21947 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220238 22254 0 0.000 A 0.000 A skip 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
220543 22347 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220580 22348 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220607 22349 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220622 22350 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220637 22351 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220665 22352 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220666 22352 0 0.000 A 0.000 A 0.00 0.00 0 0.00 Standard Canopy
220677 22355 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220704 22356 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220760 22365 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220765 22358 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220776 22357 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220787 22359 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220798 22360 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220809 22366 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
220814 22367 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220996 22380 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
223760 22645 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
231063 23140 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
235107 23426 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
235123 23427 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
235151 23428 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
235245 23435 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
235271 23436 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
220623 22350 2 0.000 A 0.000 A 0.00 0.00 22347 0.00 Same as Shade
244462 23426 2 79.000 A 0.000 A M103 50.00 0.00 0 0.00 M103-Black
244486 23435 2 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
245431 22356 2 0.000 A 0.000 A M103 0.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
217563 22057 3 0.000 A 0.000 A WHU10 0.00 0.00 0 0.00 10" Shade
235109 23427 3 0.000 A 0.000 A 0.00 0.00 23426 0.00 Same as Shade
235124 23428 3 0.000 A 0.000 A 0.00 0.00 23426 0.00 Same as Shade
235246 23436 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
238867 21947 3 0.000 A 0.000 A ST506 0.00 0.00 0 0.00 6" Stem - ½" Diameter
245475 22350 3 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
244463 23426 4 79.000 A 0.000 A M200 50.00 0.00 0 0.00 M200-White
244487 23435 4 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
245432 22356 4 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
245476 22350 4 0.000 A 0.000 A M200 0.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
215452 21947 5 1.000 A 0.000 A ST706 0.00 0.00 0 0.18 6" Stem - ¾" Diameter
217564 22057 5 13.000 A 0.000 A WHU12 0.00 0.00 0 0.00 12" Shade
219398 22254 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
220581 22348 5 0.000 A 0.000 A 0.00 0.00 22347 0.00 Same as Shade
220608 22349 5 0.000 A 0.000 A 0.00 0.00 22347 0.00 Same as Shade
220638 22351 5 0.000 A 0.000 A 0.00 0.00 22347 0.00 Same as Shade
220668 22352 5 24.000 A 0.000 A HDSMC 0.00 0.00 0 0.00 Heavy Duty Canopy
220678 22355 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
220761 22365 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
220766 22358 5 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
220777 22357 5 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
220788 22359 5 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
220799 22360 5 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
220810 22366 5 0.000 A 0.000 A SI12 0.00 0.00 0 0.00 12" Shade
220815 22367 5 0.000 A 0.000 A OI12 0.00 0.00 0 0.00 12" Shade
220997 22380 5 0.000 A 0.000 A 0.00 0.00 0 0.00 Standard Bulb E26/GU24
223756 22644 5 0.000 A 0.000 A 2700K 0.00 0.00 0 0.00 2700K - Warm White/Soft White
223761 22645 5 0.000 A 0.000 A DL 0.00 0.00 0 0.00 Domed Lens
230827 23116 5 0.000 A 0.000 A LED16.8 0.00 0.00 0 0.00 16.8W LED - 1600 Lumen
231064 23140 5 0.000 A 0.000 A LED11 0.00 0.00 0 0.00 850 Lumens
235125 23428 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
235247 23436 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
244470 23427 5 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
245134 22347 5 18.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
244464 23426 6 79.000 A 0.000 A M305 50.00 0.00 0 0.00 M305-Forest Green
244488 23435 6 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
245433 22356 6 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
245477 22350 6 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
244465 23426 8 79.000 A 0.000 A M603 50.00 0.00 0 0.00 M603-Brown
244489 23435 8 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
245434 22356 8 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
245478 22350 8 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
217565 22057 10 24.000 A 0.000 A WHU14 0.00 0.00 0 0.00 14" Shade
219399 22254 10 49.000 A 0.000 A WC 0.00 0.00 0 6.25 Wire Cage
220582 22348 10 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
220639 22351 10 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
220667 22352 10 44.000 A 0.000 A HSC 0.00 0.00 0 0.00 25° Hang Straight Canopy
220679 22355 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
220762 22365 10 18.000 A 0.000 A WGG 0.00 0.00 0 0.00 Wire Guard
220767 22358 10 10.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
220778 22357 10 10.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
220789 22359 10 10.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
220800 22360 10 10.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
220811 22366 10 18.000 A 0.000 A SI14 0.00 0.00 0 0.00 14" Shade
220816 22367 10 18.000 A 0.000 A OI14 0.00 0.00 0 0.00 14" Shade
220998 22380 10 0.000 A 0.000 A 0.00 0.00 0 0.00 Nautical LED
223757 22644 10 0.000 A 0.000 A 3000K 0.00 0.00 0 0.00 3000K - Neutral White
223762 22645 10 0.000 A 0.000 A FL 0.00 0.00 0 0.00 Flat Lens
231065 23140 10 0.000 A 0.000 A LED16 0.00 0.00 0 0.00 1250 Lumens
235126 23428 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
235248 23436 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
238868 21947 10 3.000 A 0.000 A ST512 0.00 0.00 0 0.56 12" Stem - ½" Diameter
244466 23426 10 79.000 A 0.000 A M415 50.00 0.00 0 0.00 M415-Red
244471 23427 10 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
244490 23435 10 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
245135 22347 10 18.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
245435 22356 10 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
245451 22349 10 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
245479 22350 10 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
244467 23426 12 79.000 A 0.000 A M315 50.00 0.00 0 0.00 M315-Seafoam
244491 23435 12 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
245436 22356 12 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
245452 22349 12 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
245480 22350 12 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
244468 23426 14 79.000 A 0.000 A M803 50.00 0.00 0 0.00 M803-Dark Grey
244492 23435 14 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
245437 22356 14 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
245453 22349 14 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
245481 22350 14 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
215454 21947 15 4.000 A 0.000 A ST712 0.00 0.00 0 0.92 12" Stem - ¾" Diameter
217566 22057 15 47.000 A 0.000 A WHU16 0.00 0.00 0 0.00 16" Shade
220583 22348 15 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
220640 22351 15 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
220680 22355 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
220763 22365 15 18.000 A 0.000 A CGG 0.00 0.00 0 0.00 Standard Cast Guard
220768 22358 15 10.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
220779 22357 15 10.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
220790 22359 15 10.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
220801 22360 15 10.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
220812 22366 15 30.000 A 0.000 A SI16 0.00 0.00 0 0.00 16" Shade
220817 22367 15 30.000 A 0.000 A OI16 0.00 0.00 0 0.00 16" Shade
223758 22644 15 0.000 A 0.000 A 3500K 0.00 0.00 0 0.00 3500K - Bright White
231066 23140 15 5.000 A 0.000 A LED27 0.00 0.00 0 0.00 2000 Lumens
235127 23428 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
235249 23436 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
244472 23427 15 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
245136 22347 15 18.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
244469 23426 16 79.000 A 0.000 A M210 50.00 0.00 0 0.00 M210-Cream
244493 23435 16 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
245438 22356 16 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
245454 22349 16 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
245482 22350 16 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
245455 22349 18 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
220584 22348 20 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
220641 22351 20 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
220681 22355 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
220764 22365 20 18.000 A 0.000 A TGG 0.00 0.00 0 0.00 Heavy Duty Guard
220813 22366 20 53.000 A 0.000 A SI18 0.00 0.00 0 0.00 18" Shade
220818 22367 20 53.000 A 0.000 A OI18 0.00 0.00 0 0.00 18" Shade
223759 22644 20 0.000 A 0.000 A 4000K 0.00 0.00 0 0.00 4000K - Cool White
231067 23140 20 15.000 A 0.000 A LED38 0.00 0.00 0 0.00 3000 Lumens
235128 23428 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
235250 23436 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
238869 21947 20 5.000 A 0.000 A ST518 0.00 0.00 0 1.12 18" Stem - ½" Diameter
244473 23427 20 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
245137 22347 20 18.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
245456 22349 20 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
245457 22349 22 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
245458 22349 24 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
215456 21947 25 7.000 A 0.000 A ST718 0.00 0.00 0 1.67 18" Stem - ¾" Diameter
220585 22348 25 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
220642 22351 25 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
220682 22355 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
220819 22367 25 64.000 A 0.000 A OI20 0.00 0.00 0 0.00 20" Shade
231068 23140 25 23.000 A 0.000 A LED43 0.00 0.00 0 0.00 4000 Lumens
235129 23428 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
235251 23436 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
244474 23427 25 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
245138 22347 25 18.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
237321 23436 27 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
235150 23428 28 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
237322 23436 28 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
220586 22348 30 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
220643 22351 30 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
220683 22355 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
235130 23428 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
235252 23436 30 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
238870 21947 30 7.000 A 0.000 A ST524 0.00 0.00 0 1.69 24" Stem - ½" Diameter
244475 23427 30 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
245139 22347 30 18.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
236880 22355 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237319 23428 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
245082 23436 32 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
236881 22355 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237320 23428 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
241000 23436 33 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215458 21947 35 10.000 A 0.000 A ST724 0.00 0.00 0 2.41 24" Stem - ¾" Diameter
220587 22348 35 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
220644 22351 35 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
220684 22355 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
235131 23428 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
235253 23436 35 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
244476 23427 35 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
245140 22347 35 18.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
245074 23428 36 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
245447 22355 36 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
241095 23428 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
242039 22355 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
220588 22348 40 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
220645 22351 40 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
220685 22355 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
235132 23428 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
235254 23436 40 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
238871 21947 40 12.000 A 0.000 A ST536 0.00 0.00 0 2.81 36" Stem - ½" Diameter
244477 23427 40 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
245141 22347 40 18.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
236878 22348 42 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
236879 22348 43 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
236936 22351 43 0.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
236937 22351 44 0.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
215460 21947 45 16.000 A 0.000 A ST736 0.00 0.00 0 3.90 36" Stem - ¾" Diameter
220589 22348 45 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
220646 22351 45 0.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
220686 22355 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
235133 23428 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
235255 23436 45 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
245459 22348 46 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
245483 22351 46 0.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
242044 22348 48 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
242120 22351 48 0.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
220590 22348 50 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
220647 22351 50 0.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
220687 22355 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
235134 23428 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
235256 23436 50 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
238872 21947 50 16.000 A 0.000 A ST548 0.00 0.00 0 3.93 48" Stem - ½" Diameter
215462 21947 55 22.000 A 0.000 A ST748 0.00 0.00 0 5.39 48" Stem - ¾" Diameter
220591 22348 55 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
220648 22351 55 0.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
220688 22355 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
235077 23426 55 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
235135 23428 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
235257 23436 55 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
241001 23436 58 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
220555 22347 60 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
220592 22348 60 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
220649 22351 60 0.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
220689 22355 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
235078 23426 60 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
235136 23428 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
235258 23436 60 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
241096 23428 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
242040 22355 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
220556 22347 65 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
220593 22348 65 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
220650 22351 65 0.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
220690 22355 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
235079 23426 65 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
235137 23428 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
235259 23436 65 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
220557 22347 70 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
220594 22348 70 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
220651 22351 70 0.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
220691 22355 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
235080 23426 70 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
235138 23428 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
235260 23436 70 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
242045 22348 73 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
242121 22351 73 0.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
220558 22347 75 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
220595 22348 75 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
220652 22351 75 0.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
220692 22355 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
235081 23426 75 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
235139 23428 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
235261 23436 75 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
220559 22347 80 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
220596 22348 80 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
220653 22351 80 0.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
220693 22355 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
235082 23426 80 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
235140 23428 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
235262 23436 80 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
237317 23426 82 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237318 23426 84 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
220560 22347 85 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
220597 22348 85 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
220654 22351 85 0.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
220694 22355 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
235083 23426 85 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
235141 23428 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
235263 23436 85 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
245070 23426 86 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
236876 22347 87 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
236877 22347 88 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
240990 23426 88 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
220561 22347 90 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
220598 22348 90 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
220655 22351 90 0.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
220695 22355 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
235084 23426 90 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
235142 23428 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
235264 23436 90 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
245439 22347 92 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
242034 22347 93 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
220562 22347 95 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
220599 22348 95 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
220656 22351 95 0.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
220696 22355 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
235085 23426 95 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
235143 23428 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
235265 23436 95 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241002 23436 98 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
220563 22347 100 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
220600 22348 100 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
220657 22351 100 0.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
220697 22355 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
235086 23426 100 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
235144 23428 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
235266 23436 100 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241003 23436 103 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241097 23428 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
242041 22355 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
220564 22347 105 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
220601 22348 105 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
220658 22351 105 0.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
220698 22355 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
235087 23426 105 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
235145 23428 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
235267 23436 105 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
241098 23428 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
242042 22355 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
220565 22347 110 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
220602 22348 110 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
220659 22351 110 0.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
220699 22355 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
235088 23426 110 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
235146 23428 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
235268 23436 110 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
245083 23436 111 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245084 23436 112 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
235272 23436 113 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
240991 23426 113 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
242046 22348 113 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
242122 22351 113 0.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
220566 22347 115 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
220603 22348 115 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
220660 22351 115 0.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
220700 22355 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
235089 23426 115 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
235147 23428 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
235269 23436 115 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
245075 23428 116 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245448 22355 116 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245076 23428 117 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
245449 22355 117 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
235152 23428 118 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
242035 22347 118 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
242047 22348 118 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
242123 22351 118 0.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
220567 22347 120 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
220604 22348 120 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
220661 22351 120 0.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
220701 22355 120 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
235090 23426 120 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
235148 23428 120 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
235270 23436 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
245085 23436 123 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
220568 22347 125 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
220605 22348 125 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
220662 22351 125 0.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
220702 22355 125 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
235091 23426 125 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
241004 23436 125 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
245460 22348 126 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245484 22351 126 0.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245461 22348 127 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
245485 22351 127 0.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
233243 22348 128 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
220569 22347 130 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
220606 22348 130 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
220663 22351 130 0.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
220703 22355 130 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
235092 23426 130 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
235149 23428 130 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
245450 22355 131 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
245462 22348 131 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
242043 22355 132 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242048 22348 132 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
245077 23428 133 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
220570 22347 135 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
220664 22351 135 0.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
235093 23426 135 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
241099 23428 135 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
245486 22351 136 0.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
242124 22351 138 0.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
220571 22347 140 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
235094 23426 140 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
220572 22347 145 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
235095 23426 145 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
220573 22347 150 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
235096 23426 150 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
240992 23426 153 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
220574 22347 155 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
235097 23426 155 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
240993 23426 158 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
242036 22347 158 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
220575 22347 160 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
235098 23426 160 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
242037 22347 163 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
220576 22347 165 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
235099 23426 165 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
245071 23426 166 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245072 23426 167 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
235108 23426 168 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
220577 22347 170 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
235100 23426 170 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
245440 22347 172 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
245441 22347 173 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
220578 22347 175 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
235101 23426 175 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
245073 23426 176 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
240994 23426 178 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
220579 22347 180 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
235102 23426 180 160.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
245442 22347 182 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
242038 22347 183 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
235103 23426 185 200.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
235104 23426 190 250.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
235105 23426 195 210.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
235106 23426 200 250.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass