{
"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": 130,
"filtered": 100,
"index_condition": "a.option_id in (23052,22746,23074,23043,23015,24038,24040,23027,23028,23029,23116,22644) 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')"
}
}
}| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 229899 | 23015 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230049 | 23027 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230060 | 23028 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230071 | 23029 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230215 | 23043 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230335 | 23052 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230513 | 23074 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230828 | 23116 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 245914 | 24038 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 245969 | 24040 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 245591 | 23052 | 2 | 79.000 | A | 0.000 | A | M103 | 50.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 245926 | 24038 | 2 | 0.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 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 | |
| 245943 | 24040 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 245592 | 23052 | 4 | 79.000 | A | 0.000 | A | M200 | 50.00 | 0.00 | 0 | 0.00 | M200-White | |
| 245927 | 24038 | 4 | 0.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 223756 | 22644 | 5 | 0.000 | A | 0.000 | A | 2700K | 0.00 | 0.00 | 0 | 0.00 | 2700K - Warm White/Soft White | |
| 229897 | 23015 | 5 | 5.000 | A | 0.000 | A | CGG | 0.00 | 0.00 | 0 | 1.29 | Cast Guard | |
| 230042 | 23027 | 5 | 40.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 230053 | 23028 | 5 | 40.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 230064 | 23029 | 5 | 40.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 230216 | 23043 | 5 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | No Shade | |
| 230510 | 23074 | 5 | 0.000 | A | 0.000 | A | SC | 0.00 | 0.00 | 0 | 0.00 | Standard Canopy | |
| 230827 | 23116 | 5 | 0.000 | A | 0.000 | A | LED16.8 | 0.00 | 0.00 | 0 | 0.00 | 16.8W LED - 1600 Lumen | |
| 245944 | 24040 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 245593 | 23052 | 6 | 79.000 | A | 0.000 | A | M305 | 50.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 245928 | 24038 | 6 | 0.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 245594 | 23052 | 8 | 79.000 | A | 0.000 | A | M603 | 50.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 245929 | 24038 | 8 | 0.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 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 | |
| 230043 | 23027 | 10 | 40.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 230054 | 23028 | 10 | 40.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 230065 | 23029 | 10 | 40.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 230217 | 23043 | 10 | 44.000 | A | 0.000 | A | FS | 0.00 | 0.00 | 0 | 0.00 | Flared Shade | |
| 230511 | 23074 | 10 | 44.000 | A | 0.000 | A | HSC | 0.00 | 0.00 | 0 | 0.00 | 25° Hang Straight Canopy | |
| 245595 | 23052 | 10 | 79.000 | A | 0.000 | A | M415 | 50.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 245930 | 24038 | 10 | 0.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 245945 | 24040 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 245596 | 23052 | 12 | 79.000 | A | 0.000 | A | M315 | 50.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 245931 | 24038 | 12 | 0.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 245597 | 23052 | 14 | 79.000 | A | 0.000 | A | M803 | 50.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 245932 | 24038 | 14 | 0.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 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 | |
| 229898 | 23015 | 15 | 5.000 | A | 0.000 | A | TGG | 0.00 | 0.00 | 0 | 1.29 | Heavy Duty Guard | |
| 230218 | 23043 | 15 | 66.000 | A | 0.000 | A | WH | 0.00 | 0.00 | 0 | 0.00 | Warehouse Shade | |
| 230512 | 23074 | 15 | 24.000 | A | 0.000 | A | HDSMC | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty Canopy | |
| 245946 | 24040 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 245598 | 23052 | 16 | 79.000 | A | 0.000 | A | M210 | 50.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 245933 | 24038 | 16 | 0.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 245968 | 24040 | 18 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 245961 | 24040 | 19 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 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 | |
| 245970 | 24040 | 21 | 0.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 230305 | 23052 | 22 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 245971 | 24040 | 22 | 0.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 | |
| 245947 | 24040 | 24 | 0.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 225705 | 22746 | 25 | 12.000 | A | 0.000 | A | ST536 | 0.00 | 0.00 | 0 | 0.00 | 36" Stem - ½ Diameter | |
| 245977 | 24040 | 25 | 0.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 230307 | 23052 | 26 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 245972 | 24040 | 26 | 0.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 230308 | 23052 | 28 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 245948 | 24040 | 28 | 0.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 225706 | 22746 | 30 | 16.000 | A | 0.000 | A | ST548 | 0.00 | 0.00 | 0 | 0.00 | 48" Stem - ½ Diameter | |
| 230330 | 23052 | 30 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 245949 | 24040 | 30 | 0.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 230323 | 23052 | 32 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 237082 | 23052 | 34 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 4.50 | 106-Matte Black | |
| 245950 | 24040 | 35 | 0.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 237083 | 23052 | 36 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 4.50 | 206-Matte White | |
| 230309 | 23052 | 38 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 4.50 | 307-Emerald Green | |
| 242155 | 23052 | 40 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 4.50 | 311-Jadite | |
| 245951 | 24040 | 40 | 0.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 241585 | 23052 | 42 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 4.50 | 320-Fern Green | |
| 230310 | 23052 | 44 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 4.50 | 370-Mint | |
| 245952 | 24040 | 45 | 0.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 230311 | 23052 | 46 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 4.50 | 380-Chartreuse | |
| 230312 | 23052 | 48 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 4.50 | 390-Teal | |
| 245973 | 24040 | 48 | 0.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 230313 | 23052 | 50 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 4.50 | 400-Barn Red | |
| 245953 | 24040 | 50 | 0.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 230314 | 23052 | 52 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 4.50 | 420-Orange | |
| 241586 | 23052 | 54 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 4.50 | 430-Soft Clay | |
| 245954 | 24040 | 55 | 0.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 230315 | 23052 | 56 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 4.50 | 470-Watermelon | |
| 230316 | 23052 | 58 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 4.50 | 480-Blush Pink | |
| 230317 | 23052 | 60 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 4.50 | 490-Magenta | |
| 245955 | 24040 | 60 | 0.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 230318 | 23052 | 65 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 4.50 | 495-Sherbet Orange | |
| 245956 | 24040 | 65 | 0.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 230319 | 23052 | 70 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 4.50 | 500-Buttery Yellow | |
| 245957 | 24040 | 70 | 0.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 230320 | 23052 | 75 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 4.50 | 570-Sunflower | |
| 245958 | 24040 | 75 | 0.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 230321 | 23052 | 80 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 4.50 | 600-Bronze | |
| 245959 | 24040 | 80 | 0.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 230322 | 23052 | 85 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 4.50 | 601-Chocolate | |
| 245960 | 24040 | 85 | 0.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241587 | 23052 | 88 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 4.50 | 607-Taupe | |
| 245974 | 24040 | 88 | 0.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 230324 | 23052 | 95 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 4.50 | 615-Oil-Rubbed Bronze | |
| 245962 | 24040 | 95 | 0.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241588 | 23052 | 98 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 4.50 | 630-Beige | |
| 245975 | 24040 | 98 | 0.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 230325 | 23052 | 100 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 4.50 | 700-Royal Blue | |
| 245963 | 24040 | 100 | 0.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 230326 | 23052 | 105 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 4.50 | 705-Navy | |
| 245964 | 24040 | 105 | 0.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 242156 | 23052 | 106 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 4.50 | 710-Cobalt Blue | |
| 242157 | 23052 | 107 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 4.50 | 715-Delphite Blue | |
| 245978 | 24040 | 107 | 0.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245979 | 24040 | 109 | 0.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 230327 | 23052 | 110 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 4.50 | 790-Lavender | |
| 245965 | 24040 | 110 | 0.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 230328 | 23052 | 115 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 4.50 | 800-Industrial Grey | |
| 245966 | 24040 | 115 | 0.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 230329 | 23052 | 120 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 4.50 | 805-Charcoal Granite | |
| 245967 | 24040 | 120 | 0.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 242158 | 23052 | 122 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 4.50 | 810-Graphite | |
| 245980 | 24040 | 122 | 0.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241589 | 23052 | 123 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 4.50 | 815-Light Grey | |
| 245976 | 24040 | 123 | 0.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey |