{
"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": 109,
"filtered": 100,
"index_condition": "a.option_id in (22194,22996,21970,22254,22024,21984,21967,21941,21985) 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 218476 | 21970 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 218831 | 22194 | 0 | 0.000 | A | 0.000 | A | unselected | 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 | |
| 220269 | 22024 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220303 | 21984 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220307 | 21967 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220309 | 21985 | 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 | |
| 229555 | 22996 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 218832 | 22194 | 1 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Standard Bulb E26/GU24 | ||
| 215376 | 21941 | 3 | 0.000 | A | 0.000 | A | E26 | 0.00 | 0.00 | 0 | 0.00 | E26 | |
| 215660 | 21967 | 3 | 0.000 | A | 0.000 | A | SBK | 0.00 | 0.00 | 0 | 0.00 | Standard Black | |
| 215713 | 21970 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 215974 | 21984 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 215976 | 21985 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 217095 | 22024 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 229550 | 22996 | 3 | 0.000 | A | 0.000 | A | WHA8 | 0.00 | 0.00 | 0 | 0.00 | 8" Shade | |
| 215377 | 21941 | 5 | 14.000 | A | 0.000 | A | GU24 | 0.00 | 0.00 | 0 | 3.50 | GU24 | |
| 215661 | 21967 | 5 | 5.000 | A | 0.000 | A | SWH | 0.00 | 0.00 | 0 | 0.00 | Standard White | |
| 215714 | 21970 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 215975 | 21984 | 5 | 62.000 | A | 0.000 | A | L-WL | 0.00 | 0.00 | 0 | 0.00 | Plug with Inline On/Off Switch | |
| 215977 | 21985 | 5 | 58.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 0.00 | Dusk-to-Dawn Photocell | |
| 217096 | 22024 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 218833 | 22194 | 5 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Integrated LED | ||
| 219398 | 22254 | 5 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 229551 | 22996 | 5 | 13.000 | A | 0.000 | A | WHA10 | 0.00 | 0.00 | 0 | 0.00 | 10" Shade | |
| 215662 | 21967 | 10 | 10.000 | A | 0.000 | A | CSB | 0.00 | 0.00 | 0 | 0.00 | Black Cloth | |
| 215715 | 21970 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 217097 | 22024 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 219399 | 22254 | 10 | 49.000 | A | 0.000 | A | WC | 0.00 | 0.00 | 0 | 6.25 | Wire Cage | |
| 215663 | 21967 | 15 | 10.000 | A | 0.000 | A | SLVR | 0.00 | 0.00 | 0 | 0.00 | Silver Cloth | |
| 215716 | 21970 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 217098 | 22024 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 215738 | 21970 | 18 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 215731 | 21970 | 19 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 215664 | 21967 | 20 | 10.000 | A | 0.000 | A | CRM | 0.00 | 0.00 | 0 | 0.00 | Creme Cloth | |
| 217099 | 22024 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 237036 | 21970 | 21 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 237037 | 21970 | 22 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 215717 | 21970 | 24 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 215665 | 21967 | 25 | 10.000 | A | 0.000 | A | BPNK | 0.00 | 0.00 | 0 | 0.00 | Blush Pink Cloth | |
| 217100 | 22024 | 25 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 242135 | 21970 | 25 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 241141 | 21970 | 26 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 236886 | 22024 | 27 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 215718 | 21970 | 28 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 236887 | 22024 | 28 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 215666 | 21967 | 30 | 20.000 | A | 0.000 | A | CNF | 0.00 | 0.00 | 0 | 0.00 | Confetti Cloth | |
| 215719 | 21970 | 30 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 217101 | 22024 | 30 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 241605 | 22024 | 33 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 215667 | 21967 | 35 | 10.000 | A | 0.000 | A | RST | 0.00 | 0.00 | 0 | 0.00 | Rust Cloth | |
| 215720 | 21970 | 35 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 217102 | 22024 | 35 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 215668 | 21967 | 40 | 15.000 | A | 0.000 | A | RBS | 0.00 | 0.00 | 0 | 0.00 | Barn Red & Black Swirl Cloth | |
| 215721 | 21970 | 40 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 217103 | 22024 | 40 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 215669 | 21967 | 45 | 10.000 | A | 0.000 | A | ORG | 0.00 | 0.00 | 0 | 0.00 | Orange Cloth | |
| 215722 | 21970 | 45 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 217104 | 22024 | 45 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 241142 | 21970 | 48 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 215670 | 21967 | 50 | 10.000 | A | 0.000 | A | YLW | 0.00 | 0.00 | 0 | 0.00 | Buttery Yellow Cloth | |
| 215723 | 21970 | 50 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 217105 | 22024 | 50 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 215671 | 21967 | 55 | 10.000 | A | 0.000 | A | NGRN | 0.00 | 0.00 | 0 | 0.00 | Neon Green Cloth | |
| 215724 | 21970 | 55 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 217106 | 22024 | 55 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 241606 | 22024 | 58 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 215672 | 21967 | 60 | 10.000 | A | 0.000 | A | EGRN | 0.00 | 0.00 | 0 | 0.00 | Emerald Green Cloth | |
| 215725 | 21970 | 60 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 217107 | 22024 | 60 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 215673 | 21967 | 65 | 20.000 | A | 0.000 | A | FGRN | 0.00 | 0.00 | 0 | 0.00 | Fern Green Chevron Cloth | |
| 215726 | 21970 | 65 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 217108 | 22024 | 65 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 215727 | 21970 | 70 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 217109 | 22024 | 70 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 243095 | 21967 | 70 | 10.000 | A | 0.000 | A | SFM | 0.00 | 0.00 | 0 | 0.00 | Seafoam Cloth | |
| 215728 | 21970 | 75 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 217110 | 22024 | 75 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 243096 | 21967 | 75 | 10.000 | A | 0.000 | A | SBLU | 0.00 | 0.00 | 0 | 0.00 | Sky Blue Cloth | |
| 215729 | 21970 | 80 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 217111 | 22024 | 80 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 243097 | 21967 | 80 | 10.000 | A | 0.000 | A | RBLU | 0.00 | 0.00 | 0 | 0.00 | Royal Blue Cloth | |
| 215730 | 21970 | 85 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 217112 | 22024 | 85 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 243098 | 21967 | 85 | 10.000 | A | 0.000 | A | NVY | 0.00 | 0.00 | 0 | 0.00 | Navy Cloth | |
| 217113 | 22024 | 90 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 241143 | 21970 | 90 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 215732 | 21970 | 95 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 217114 | 22024 | 95 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241144 | 21970 | 98 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 241607 | 22024 | 98 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 215733 | 21970 | 100 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 217115 | 22024 | 100 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241608 | 22024 | 103 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 215734 | 21970 | 105 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 217116 | 22024 | 105 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 215735 | 21970 | 110 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 217117 | 22024 | 110 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 242136 | 21970 | 112 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 225921 | 22024 | 113 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 242137 | 21970 | 113 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 215736 | 21970 | 115 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 217118 | 22024 | 115 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 215737 | 21970 | 120 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 217119 | 22024 | 120 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 241609 | 22024 | 123 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 242138 | 21970 | 123 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241145 | 21970 | 125 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey |