{
"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": 123,
"filtered": 100,
"index_condition": "a.option_id in (22168,22176,22254,22181,22182,21984,21967,22026,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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 220122 | 22168 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220139 | 22176 | 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 | |
| 220280 | 22181 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220281 | 22182 | 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 | |
| 220317 | 22026 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 244854 | 22176 | 2 | 79.000 | A | 0.000 | A | M103 | 50.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 215660 | 21967 | 3 | 0.000 | A | 0.000 | A | SBK | 0.00 | 0.00 | 0 | 0.00 | Standard 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 | |
| 217132 | 22026 | 3 | 0.000 | A | 0.000 | A | E26 | 0.00 | 0.00 | 0 | 0.00 | Standard Incandescent | |
| 218479 | 22168 | 3 | 0.000 | A | 0.000 | A | DBW8 | 0.00 | 0.00 | 0 | 0.00 | 8" Shade | |
| 218648 | 22182 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 244855 | 22176 | 4 | 79.000 | A | 0.000 | A | M200 | 50.00 | 0.00 | 0 | 0.00 | M200-White | |
| 215661 | 21967 | 5 | 5.000 | A | 0.000 | A | SWH | 0.00 | 0.00 | 0 | 0.00 | Standard White | |
| 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 | |
| 217133 | 22026 | 5 | 14.000 | A | 0.000 | A | GU24 | 0.00 | 0.00 | 0 | 0.00 | GU24 | |
| 218480 | 22168 | 5 | 12.000 | A | 0.000 | A | DBW10 | 0.00 | 0.00 | 0 | 0.00 | 10" Shade | |
| 218649 | 22182 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 219398 | 22254 | 5 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 244862 | 22181 | 5 | 11.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 244856 | 22176 | 6 | 79.000 | A | 0.000 | A | M305 | 50.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 244857 | 22176 | 8 | 79.000 | A | 0.000 | A | M603 | 50.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 215662 | 21967 | 10 | 10.000 | A | 0.000 | A | CSB | 0.00 | 0.00 | 0 | 0.00 | Black Cloth | |
| 218650 | 22182 | 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 | |
| 244858 | 22176 | 10 | 79.000 | A | 0.000 | A | M415 | 50.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 244863 | 22181 | 10 | 11.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 244859 | 22176 | 12 | 79.000 | A | 0.000 | A | M315 | 50.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 244860 | 22176 | 14 | 79.000 | A | 0.000 | A | M803 | 50.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 215663 | 21967 | 15 | 10.000 | A | 0.000 | A | SLVR | 0.00 | 0.00 | 0 | 0.00 | Silver Cloth | |
| 218651 | 22182 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 244861 | 22176 | 15 | 79.000 | A | 0.000 | A | M210 | 50.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 244864 | 22181 | 15 | 11.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 215664 | 21967 | 20 | 10.000 | A | 0.000 | A | CRM | 0.00 | 0.00 | 0 | 0.00 | Creme Cloth | |
| 218652 | 22182 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 244865 | 22181 | 20 | 11.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 215665 | 21967 | 25 | 10.000 | A | 0.000 | A | BPNK | 0.00 | 0.00 | 0 | 0.00 | Blush Pink Cloth | |
| 218653 | 22182 | 25 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 244866 | 22181 | 25 | 11.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 236896 | 22182 | 27 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 236897 | 22182 | 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 | |
| 218654 | 22182 | 30 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 244867 | 22181 | 30 | 11.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 241630 | 22182 | 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 | |
| 218655 | 22182 | 35 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 244868 | 22181 | 35 | 11.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 215668 | 21967 | 40 | 15.000 | A | 0.000 | A | RBS | 0.00 | 0.00 | 0 | 0.00 | Barn Red & Black Swirl Cloth | |
| 218656 | 22182 | 40 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 244869 | 22181 | 40 | 11.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 215669 | 21967 | 45 | 10.000 | A | 0.000 | A | ORG | 0.00 | 0.00 | 0 | 0.00 | Orange Cloth | |
| 218657 | 22182 | 45 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 215670 | 21967 | 50 | 10.000 | A | 0.000 | A | YLW | 0.00 | 0.00 | 0 | 0.00 | Buttery Yellow Cloth | |
| 218658 | 22182 | 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 | |
| 218570 | 22176 | 55 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 218659 | 22182 | 55 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 241631 | 22182 | 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 | |
| 218571 | 22176 | 60 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 218660 | 22182 | 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 | |
| 218572 | 22176 | 65 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 218661 | 22182 | 65 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 218573 | 22176 | 70 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 218662 | 22182 | 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 | |
| 218574 | 22176 | 75 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 218663 | 22182 | 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 | |
| 218575 | 22176 | 80 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 218664 | 22182 | 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 | |
| 236892 | 22176 | 82 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 236893 | 22176 | 83 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 218576 | 22176 | 85 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 218665 | 22182 | 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 | |
| 245284 | 22176 | 86 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 241625 | 22176 | 88 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 218577 | 22176 | 90 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 218666 | 22182 | 90 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 218578 | 22176 | 95 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 218667 | 22182 | 95 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241632 | 22182 | 98 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 218579 | 22176 | 100 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 218668 | 22182 | 100 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241633 | 22182 | 103 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 218580 | 22176 | 105 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 218669 | 22182 | 105 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 218581 | 22176 | 110 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 218670 | 22182 | 110 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 225923 | 22182 | 113 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 241626 | 22176 | 113 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 218582 | 22176 | 115 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 218671 | 22182 | 115 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 218583 | 22176 | 120 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 218672 | 22182 | 120 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 241634 | 22182 | 123 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 218584 | 22176 | 125 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 218585 | 22176 | 130 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 218586 | 22176 | 135 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 218587 | 22176 | 140 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 218588 | 22176 | 145 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 218589 | 22176 | 150 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241627 | 22176 | 153 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 218590 | 22176 | 155 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241628 | 22176 | 158 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 218591 | 22176 | 160 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 218592 | 22176 | 165 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 245285 | 22176 | 166 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245286 | 22176 | 167 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 225922 | 22176 | 168 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 218593 | 22176 | 170 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 218594 | 22176 | 175 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 245287 | 22176 | 176 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241629 | 22176 | 178 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey |