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 (
    6265, 21970, 23624, 22962, 18902, 21971, 
    1596, 13651, 23332, 22853, 21928, 1607, 
    1628, 22914, 22900, 22901, 16490, 16491, 
    23530, 22958, 23544, 22906, 22794, 
    22795, 22796, 22797, 22798, 22902, 
    22949
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00584

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": 421,
          "filtered": 100,
          "index_condition": "a.option_id in (6265,21970,23624,22962,18902,21971,1596,13651,23332,22853,21928,1607,1628,22914,22900,22901,16490,16491,23530,22958,23544,22906,22794,22795,22796,22797,22798,22902,22949) 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
149578 13651 0 0.000 A 0.000 A 1/2 0.00 0.00 0 0.00 1/2" Receiver
217850 21928 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please select
218476 21970 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
220227 21971 0 0.000 A 0.000 A skip 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
227176 22853 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
227898 22900 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Select Option
227905 22901 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
227924 22902 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
227990 22906 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
228066 16491 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
228067 16490 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
228135 22914 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
228547 22949 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
228754 22958 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
228891 22962 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
233603 23332 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
236647 23530 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
237260 23544 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
238809 23624 0 0.000 A 0.000 A SM 0.00 0.00 0 0.00 Small Coupler
177690 16490 1 0.000 A 0.000 A PMDBSP8 0.00 0.00 0 0.00 8' Smooth Pole
177699 16491 1 0.000 A 0.000 A 100 0.00 0.00 0 0.00 Black
215160 21928 1 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
177691 16490 2 29.000 A 0.000 A PMDBFP8 0.00 0.00 0 0.00 8' Fluted Pole
177697 16491 2 0.000 A 0.000 A 200 0.00 0.00 0 0.00 White
177698 16491 3 0.000 A 0.000 A 975 0.00 0.00 0 0.00 Galvanized
215713 21970 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
215745 21971 3 0.000 A 0.000 A 0.00 0.00 22952 0.00 Same as Shade
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
227163 22853 3 0.000 A 0.000 A ST506 0.00 0.00 0 0.00 6" Stem - ½" Diameter
227868 22900 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
228512 22949 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
228719 22958 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
228869 22962 3 0.000 A 0.000 A SBK 0.00 0.00 0 0.00 Standard Black
237261 23544 3 0.000 A 0.000 A G 0.00 0.00 0 0.00 Gooseneck
245599 23332 3 11.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
197117 18902 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
203921 6265 5 0.000 A 0.000 A SM-1/2 0.00 0.00 0 0.00 Small 1/2" Coupler
215161 21928 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
215714 21970 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
215746 21971 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-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
227164 22853 5 1.000 A 0.000 A ST706 0.00 0.00 0 0.18 6" Stem - ¾" Diameter
227869 22900 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
227906 22901 5 0.000 A 0.000 A 1/2 0.00 0.00 0 0.00 1/2" Receiver
227925 22902 5 0.000 A 0.000 A 1/2 0.00 0.00 0 0.00 1/2" Reciever
227991 22906 5 0.000 A 0.000 A SCH10-GLASS 0.00 0.00 0 0.00 Small Opaque Glass
228136 22914 5 0.000 A 0.000 A 1/2 0.00 0.00 0 0.00 1/2" Reciever
228513 22949 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
228720 22958 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
228870 22962 5 5.000 A 0.000 A SWH 0.00 0.00 0 0.00 Standard White
236648 23530 5 0.000 A 0.000 A 1/2 0.00 0.00 0 0.00 1/2"
237262 23544 5 0.000 A 0.000 A S 0.00 0.00 0 0.00 Stem
238810 23624 5 0.000 A 0.000 A LG 0.00 0.00 0 0.00 Large Coupler
245600 23332 6 11.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
233605 21971 8 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
245601 23332 9 11.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
15765 1596 10 0.000 A 0.000 A 1/2 0.00 0.00 0 0.00 1/2" Opening
16498 1628 10 0.000 A 0.000 A 1/2 0.00 0.00 0 0.00 1/2" Canopy
61310 6265 10 0.000 A 0.000 A LG-1/2 0.00 0.00 0 0.00 Large 1/2" Coupler
149579 13651 10 0.000 A 0.000 A 3/4 0.00 0.00 0 0.00 3/4" Receiver
197118 18902 10 24.000 A 0.000 A SC 0.00 0.00 0 0.00 Standard Cord Canopy
215162 21928 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
215715 21970 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
215747 21971 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
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
227165 22853 10 3.000 A 0.000 A ST512 0.00 0.00 0 0.56 12" Stem - ½" Diameter
227870 22900 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
227907 22901 10 0.000 A 0.000 A 3/4 0.00 0.00 0 0.00 3/4" Receiver
227926 22902 10 0.000 A 0.000 A 3/4 0.00 0.00 0 0.00 3/4" Reciever
227992 22906 10 36.000 A 0.000 A SCH14-GLASS 0.00 0.00 0 0.00 Large Opaque Glass
228137 22914 10 0.000 A 0.000 A 3/4 0.00 0.00 0 0.00 3/4" Reciever
228514 22949 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
228721 22958 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
228871 22962 10 10.000 A 0.000 A CSB 0.00 0.00 0 0.00 Black Cloth
236649 23530 10 0.000 A 0.000 A 3/4 0.00 0.00 0 0.00 3/4"
237263 23544 10 0.000 A 0.000 A C 0.00 0.00 0 0.00 Cord
245602 23332 12 11.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
15766 1596 15 0.000 A 0.000 A 3/4 0.00 0.00 0 0.00 3/4" Opening
215163 21928 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
215716 21970 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
215748 21971 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
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
227166 22853 15 4.000 A 0.000 A ST712 0.00 0.00 0 0.92 12" Stem - ¾" Diameter
227871 22900 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
227993 22906 15 0.000 A 0.000 A SCHCL10-GLASS 0.00 0.00 0 0.00 Small Clear Glass
228515 22949 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
228722 22958 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
228872 22962 15 10.000 A 0.000 A SLVR 0.00 0.00 0 0.00 Silver Cloth
237264 23544 15 0.000 A 0.000 A CN 0.00 0.00 0 0.00 Chain
245603 23332 15 11.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
215738 21970 18 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
227893 22900 18 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
245604 23332 18 11.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
215731 21970 19 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
227886 22900 19 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
61311 6265 20 0.000 A 0.000 A LG-3/4 0.00 0.00 0 0.00 Large 3/4" Coupler
143617 1628 20 0.000 A 0.000 A 3/4 0.00 0.00 0 0.00 3/4" Canopy
215164 21928 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
215749 21971 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
227167 22853 20 5.000 A 0.000 A ST518 0.00 0.00 0 1.12 18" Stem - ½" Diameter
227994 22906 20 36.000 A 0.000 A SCHCL14-GLASS 0.00 0.00 0 0.00 Large Clear Glass
228516 22949 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
228723 22958 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
228873 22962 20 10.000 A 0.000 A CRM 0.00 0.00 0 0.00 Creme Cloth
237265 23544 20 0.000 A 0.000 A W 0.00 0.00 0 0.00 Sconce
237036 21970 21 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237216 22900 21 7.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
245605 23332 21 11.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
228881 22962 22 10.000 A 0.000 A BPNK 0.00 0.00 0 0.00 Blush Pink Cloth
237037 21970 22 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237217 22900 22 7.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
216935 21928 23 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
228890 22962 23 20.000 A 0.000 A CNF 0.00 0.00 0 0.00 Confetti Cloth
215717 21970 24 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
227872 22900 24 7.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
215165 21928 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
215750 21971 25 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
227168 22853 25 7.000 A 0.000 A ST718 0.00 0.00 0 1.67 18" Stem - ¾" Diameter
228517 22949 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
228724 22958 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
228874 22962 25 10.000 A 0.000 A RST 0.00 0.00 0 0.00 Rust Cloth
237266 23544 25 0.000 A 0.000 A F 0.00 0.00 0 0.00 Flush
242135 21970 25 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
245606 23332 25 11.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
241141 21970 26 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
242618 22900 26 7.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
242950 22958 26 0.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237214 21928 27 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237345 22949 27 0.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
242951 22958 27 0.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
215718 21970 28 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
227873 22900 28 7.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
237215 21928 28 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237346 22949 28 0.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
167426 1607 30 0.000 A 0.000 A WC8 0.00 0.00 0 0.00 8" Wire Cage
215166 21928 30 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
215719 21970 30 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
215751 21971 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Rust
227169 22853 30 7.000 A 0.000 A ST524 0.00 0.00 0 1.69 24" Stem - ½" Diameter
227874 22900 30 7.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
228518 22949 30 0.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
228725 22958 30 0.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
228875 22962 30 15.000 A 0.000 A RBS 0.00 0.00 0 0.00 Barn Red & Black Swirl Cloth
237267 23544 30 0.000 A 0.000 A FSF 0.00 0.00 0 0.00 Semi-Flush
237140 21971 32 6.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237141 21971 33 6.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
242608 22958 33 0.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
242613 22949 33 0.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
242623 21928 33 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215167 21928 35 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
215720 21970 35 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
215752 21971 35 6.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
227170 22853 35 10.000 A 0.000 A ST724 0.00 0.00 0 2.41 24" Stem - ¾" Diameter
227875 22900 35 7.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
228519 22949 35 0.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
228726 22958 35 0.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
228876 22962 35 10.000 A 0.000 A ORG 0.00 0.00 0 0.00 Orange Cloth
16111 1607 40 0.000 A 0.000 A WC10 0.00 0.00 0 0.00 10" Wire Cage
215168 21928 40 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
215721 21970 40 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
215753 21971 40 6.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
226462 22798 40 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
227171 22853 40 12.000 A 0.000 A ST536 0.00 0.00 0 2.81 36" Stem - ½" Diameter
227876 22900 40 7.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
228520 22949 40 0.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
228727 22958 40 0.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
228877 22962 40 10.000 A 0.000 A YLW 0.00 0.00 0 0.00 Buttery Yellow Cloth
139967 1607 45 0.000 A 0.000 A WC11 0.00 0.00 0 0.00 11" Wire Cage
215169 21928 45 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
215722 21970 45 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
215754 21971 45 6.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
227172 22853 45 16.000 A 0.000 A ST736 0.00 0.00 0 3.90 36" Stem - ¾" Diameter
227877 22900 45 7.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
228521 22949 45 0.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
228728 22958 45 0.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
228878 22962 45 10.000 A 0.000 A NGRN 0.00 0.00 0 0.00 Neon Green Cloth
241142 21970 48 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
242619 22900 48 7.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
16110 1607 50 0.000 A 0.000 A WC12 0.00 0.00 0 0.00 12" Wire Cage
215170 21928 50 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
215723 21970 50 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
215755 21971 50 6.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
226481 22798 50 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
227173 22853 50 16.000 A 0.000 A ST548 0.00 0.00 0 3.93 48" Stem - ½" Diameter
227878 22900 50 7.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
228522 22949 50 0.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
228729 22958 50 0.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
228879 22962 50 10.000 A 0.000 A EGRN 0.00 0.00 0 0.00 Emerald Green Cloth
244281 22798 53 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
139968 1607 55 0.000 A 0.000 A WC13 0.00 0.00 0 0.00 13" Wire Cage
215171 21928 55 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
215724 21970 55 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
215756 21971 55 6.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
226465 22798 55 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
227174 22853 55 22.000 A 0.000 A ST748 0.00 0.00 0 5.39 48" Stem - ¾" Diameter
227879 22900 55 7.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
228523 22949 55 0.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
228730 22958 55 0.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
228880 22962 55 20.000 A 0.000 A FGRN 0.00 0.00 0 0.00 Fern Green Chevron Cloth
233578 23332 55 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
242609 22958 58 0.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
242614 22949 58 0.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
242624 21928 58 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
16109 1607 60 0.000 A 0.000 A WC14 0.00 0.00 0 0.00 14" Wire Cage
215172 21928 60 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
215725 21970 60 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
215757 21971 60 6.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
226466 22798 60 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
227880 22900 60 7.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
228524 22949 60 0.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
228731 22958 60 0.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
233579 23332 60 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
139969 1607 65 0.000 A 0.000 A WC15 0.00 0.00 0 0.00 15" Wire Cage
215173 21928 65 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
215726 21970 65 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
215758 21971 65 6.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
227881 22900 65 7.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
228525 22949 65 0.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
228732 22958 65 0.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
233580 23332 65 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
244282 22798 65 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
16108 1607 70 0.000 A 0.000 A WC16 0.00 0.00 0 0.00 16" Wire Cage
215174 21928 70 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
215727 21970 70 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
215759 21971 70 6.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
227882 22900 70 7.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
228526 22949 70 0.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
228733 22958 70 0.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
228882 22962 70 10.000 A 0.000 A SFM 0.00 0.00 0 0.00 Seafoam Cloth
233581 23332 70 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
239948 22798 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
215175 21928 75 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
215728 21970 75 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
215760 21971 75 6.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
227883 22900 75 7.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
228527 22949 75 0.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
228734 22958 75 0.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
228883 22962 75 10.000 A 0.000 A SBLU 0.00 0.00 0 0.00 Sky Blue Cloth
233582 23332 75 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
239720 23332 78 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
16107 1607 80 0.000 A 0.000 A WC17 0.00 0.00 0 0.00 17" Wire Cage
215176 21928 80 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
215729 21970 80 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
215761 21971 80 6.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
227884 22900 80 7.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
228528 22949 80 0.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
228735 22958 80 0.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
228884 22962 80 10.000 A 0.000 A RBLU 0.00 0.00 0 0.00 Royal Blue Cloth
233583 23332 80 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Rust
237218 23332 82 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237219 23332 83 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
215177 21928 85 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
215730 21970 85 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
215762 21971 85 6.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
227885 22900 85 7.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
228529 22949 85 0.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
228736 22958 85 0.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
228885 22962 85 10.000 A 0.000 A NVY 0.00 0.00 0 0.00 Navy Cloth
233584 23332 85 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
233570 23332 87 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
242620 22900 88 7.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
246126 23332 88 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
16106 1607 90 0.000 A 0.000 A WC18 0.00 0.00 0 0.00 18" Wire Cage
215178 21928 90 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
215763 21971 90 6.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
226472 22798 90 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
228530 22949 90 0.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
228737 22958 90 0.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
233585 23332 90 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
241143 21970 90 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
215179 21928 95 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
215732 21970 95 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
215764 21971 95 6.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
227887 22900 95 7.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
228531 22949 95 0.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
228738 22958 95 0.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
233586 23332 95 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
241144 21970 98 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
242610 22958 98 0.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
242615 22949 98 0.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
242621 22900 98 7.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
242625 21928 98 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
16105 1607 100 13.000 A 0.000 A WC20 0.00 0.00 0 0.00 20" Wire Cage
215180 21928 100 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
215733 21970 100 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
215765 21971 100 6.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
226474 22798 100 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
227888 22900 100 7.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
228532 22949 100 0.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
228739 22958 100 0.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
233587 23332 100 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
242611 22958 103 0.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
242616 22949 103 0.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
242626 21928 103 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
215181 21928 105 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
215734 21970 105 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
215766 21971 105 6.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
227889 22900 105 7.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
228533 22949 105 0.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
228740 22958 105 0.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
233588 23332 105 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
215182 21928 110 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
215735 21970 110 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
215767 21971 110 6.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
227890 22900 110 7.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
228534 22949 110 0.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
228741 22958 110 0.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
233589 23332 110 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
242136 21970 112 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
246127 23332 112 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
242137 21970 113 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
215183 21928 115 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
215736 21970 115 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
215768 21971 115 6.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
226477 22798 115 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
227891 22900 115 7.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
228535 22949 115 0.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
228742 22958 115 0.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
233590 23332 115 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
215184 21928 120 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
215737 21970 120 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
215769 21971 120 6.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
227892 22900 120 7.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
228536 22949 120 0.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
228743 22958 120 0.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
233591 23332 120 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
226483 22798 123 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite
242138 21970 123 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
242622 22900 123 7.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242627 21928 123 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
215770 21971 125 6.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
228537 22949 125 0.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
228744 22958 125 0.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
233592 23332 125 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
241145 21970 125 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242612 22958 128 0.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242617 22949 128 0.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
215771 21971 130 6.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
227894 22900 130 7.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
233593 23332 130 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
215772 21971 135 6.000 A 0.000 A 355 0.00 0.00 0 0.00 355-Jadite
227895 22900 135 7.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
233594 23332 135 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
215773 21971 140 11.000 A 0.000 A 750 0.00 0.00 0 0.00 750-Cobalt Blue
227896 22900 140 7.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
233595 23332 140 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
215774 21971 145 11.000 A 0.000 A 765 0.00 0.00 0 0.00 765-Delphite Blue
227897 22900 145 7.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
233596 23332 145 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
215775 21971 150 11.000 A 0.000 A 850 0.00 0.00 0 0.00 850-Graphite
228548 22949 150 0.000 A 0.000 A 110 0.00 0.00 0 0.00 110-Black
228755 22958 150 0.000 A 0.000 A 110 0.00 0.00 0 0.00 110-Black
233597 23332 150 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
246128 23332 153 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
228549 22949 155 0.000 A 0.000 A 210 0.00 0.00 0 0.00 210-White
228756 22958 155 0.000 A 0.000 A 210 0.00 0.00 0 0.00 210-White
233598 23332 155 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
246129 23332 158 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
228550 22949 160 0.000 A 0.000 A 310 0.00 0.00 0 0.00 310-Vintage Green
228757 22958 160 0.000 A 0.000 A 310 0.00 0.00 0 0.00 310-Vintage Green
233599 23332 160 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
228538 22949 165 0.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
228745 22958 165 0.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
233600 23332 165 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
233574 23332 166 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
233575 23332 167 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
228551 22949 168 0.000 A 0.000 A 411 0.00 0.00 0 0.00 411-Cherry Red
228758 22958 168 0.000 A 0.000 A 411 0.00 0.00 0 0.00 411-Cherry Red
233604 23332 168 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
228552 22949 170 0.000 A 0.000 A 510 0.00 0.00 0 0.00 510-Yellow
228759 22958 170 0.000 A 0.000 A 510 0.00 0.00 0 0.00 510-Yellow
233601 23332 170 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
228553 22949 175 0.000 A 0.000 A 610 0.00 0.00 0 0.00 610-Bronze
228760 22958 175 0.000 A 0.000 A 610 0.00 0.00 0 0.00 610-Bronze
233602 23332 175 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
233576 23332 176 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
246130 23332 178 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
228539 22949 180 0.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
228746 22958 180 0.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
233987 23332 180 93.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
228540 22949 185 0.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
228747 22958 185 0.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
233988 23332 185 93.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
228541 22949 190 0.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
228748 22958 190 0.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
233989 23332 190 93.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
228554 22949 195 0.000 A 0.000 A 910 0.00 0.00 0 0.00 910-Metallic Chrome
228761 22958 195 0.000 A 0.000 A 910 0.00 0.00 0 0.00 910-Metallic Chrome
233990 23332 195 93.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
233991 23332 195 93.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
228542 22949 200 44.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
228749 22958 200 22.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
228543 22949 210 44.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
228750 22958 210 22.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
228544 22949 215 44.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
228751 22958 215 22.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
228545 22949 220 44.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
228752 22958 220 22.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
228546 22949 225 44.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
228753 22958 225 22.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass