{
"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": 127,
"filtered": 100,
"index_condition": "a.option_id in (22986,23523,23524,22911,22912,21941) 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 220318 | 21941 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 228071 | 22911 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 228102 | 22912 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 229352 | 22986 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 236498 | 23523 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 236530 | 23524 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 215376 | 21941 | 3 | 0.000 | A | 0.000 | A | E26 | 0.00 | 0.00 | 0 | 0.00 | E26 | |
| 228072 | 22912 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 229346 | 22986 | 3 | 0.000 | A | 0.000 | A | ULW12 | 0.00 | 0.00 | 0 | 0.00 | 12" Shade | |
| 236468 | 23523 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 236499 | 23524 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 23523 | 0.00 | Same as Shade | ||
| 215377 | 21941 | 5 | 14.000 | A | 0.000 | A | GU24 | 0.00 | 0.00 | 0 | 3.50 | GU24 | |
| 228069 | 22911 | 5 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 228073 | 22912 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 229347 | 22986 | 5 | 13.000 | A | 0.000 | A | ULW14 | 0.00 | 0.00 | 0 | 0.00 | 14" Shade | |
| 236469 | 23523 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 236500 | 23524 | 5 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 228070 | 22911 | 10 | 49.000 | A | 0.000 | A | WC | 0.00 | 0.00 | 0 | 0.00 | Wire Cage | |
| 228074 | 22912 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 229348 | 22986 | 10 | 24.000 | A | 0.000 | A | ULW16 | 0.00 | 0.00 | 0 | 0.00 | 16" Shade | |
| 236470 | 23523 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 236501 | 23524 | 10 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 228075 | 22912 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 229349 | 22986 | 15 | 36.000 | A | 0.000 | A | ULW18 | 0.00 | 0.00 | 0 | 0.00 | 18" Shade | |
| 236471 | 23523 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 236502 | 23524 | 15 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 236493 | 23523 | 18 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 236486 | 23523 | 19 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 228076 | 22912 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 236503 | 23524 | 20 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 236650 | 22986 | 20 | 47.000 | A | 0.000 | A | ULW20 | 0.00 | 0.00 | 0 | 0.00 | 20" Shade | |
| 239867 | 23523 | 21 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 239868 | 23523 | 23 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 236472 | 23523 | 24 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 228077 | 22912 | 25 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 236504 | 23524 | 25 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 241640 | 23523 | 26 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 237170 | 22912 | 27 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 236473 | 23523 | 28 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 237171 | 22912 | 28 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 228078 | 22912 | 30 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 236474 | 23523 | 30 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 236505 | 23524 | 30 | 0.000 | A | 0.000 | A | 980 | 0.00 | 0.00 | 0 | 0.00 | 980-Brushed Aluminum | |
| 242721 | 22912 | 31 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 241120 | 22912 | 33 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 228079 | 22912 | 35 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 236475 | 23523 | 35 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 236506 | 23524 | 35 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 239869 | 23524 | 37 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 239870 | 23524 | 38 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 228080 | 22912 | 40 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 236476 | 23523 | 40 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 236507 | 23524 | 40 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 241645 | 23524 | 43 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 228081 | 22912 | 45 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 236477 | 23523 | 45 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 236508 | 23524 | 45 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 241641 | 23523 | 48 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 228082 | 22912 | 50 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 236478 | 23523 | 50 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 236509 | 23524 | 50 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 228083 | 22912 | 55 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 236479 | 23523 | 55 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 236510 | 23524 | 55 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 241121 | 22912 | 58 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 228084 | 22912 | 60 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 236480 | 23523 | 60 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 236511 | 23524 | 60 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 228085 | 22912 | 65 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 236481 | 23523 | 65 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 236512 | 23524 | 65 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 241646 | 23524 | 68 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 228086 | 22912 | 70 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 236482 | 23523 | 70 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 236513 | 23524 | 70 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 228087 | 22912 | 75 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 236483 | 23523 | 75 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 236514 | 23524 | 75 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 228088 | 22912 | 80 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 236484 | 23523 | 80 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 236515 | 23524 | 80 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 228089 | 22912 | 85 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 236485 | 23523 | 85 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 236516 | 23524 | 85 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 228090 | 22912 | 90 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 236517 | 23524 | 90 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 241642 | 23523 | 90 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 228091 | 22912 | 95 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 236487 | 23523 | 95 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 236518 | 23524 | 95 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 241122 | 22912 | 98 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 241643 | 23523 | 98 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 228092 | 22912 | 100 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 236488 | 23523 | 100 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 236519 | 23524 | 100 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 236489 | 23523 | 105 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 236520 | 23524 | 105 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241123 | 22912 | 105 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 241647 | 23524 | 108 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 228093 | 22912 | 110 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 236490 | 23523 | 110 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 236521 | 23524 | 110 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241648 | 23524 | 113 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 228094 | 22912 | 115 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 236491 | 23523 | 115 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 236522 | 23524 | 115 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 242722 | 22912 | 116 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242723 | 22912 | 118 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 228095 | 22912 | 120 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 236492 | 23523 | 120 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 236523 | 23524 | 120 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 241644 | 23523 | 123 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 228096 | 22912 | 125 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 236524 | 23524 | 125 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 242852 | 23523 | 125 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 242853 | 23523 | 127 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242854 | 23523 | 129 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 228097 | 22912 | 130 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 242855 | 23523 | 131 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 242724 | 22912 | 132 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241124 | 22912 | 133 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 236525 | 23524 | 135 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 241649 | 23524 | 138 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 242856 | 23524 | 140 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 242857 | 23524 | 142 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242858 | 23524 | 144 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 242859 | 23524 | 146 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite |