{
"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": 138,
"filtered": 100,
"index_condition": "a.option_id in (23268,23270,23233,23234,23410,23236,23237,23238,23239,23240,23229,23230,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 | |
| 230828 | 23116 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232268 | 23229 | 0 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 232300 | 23230 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232387 | 23233 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232392 | 23234 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232408 | 23236 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232419 | 23237 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232430 | 23238 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232459 | 23239 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232472 | 23240 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232962 | 23268 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 232975 | 23270 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 234804 | 23410 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 244590 | 23233 | 2 | 79.000 | A | 0.000 | A | M103 | 50.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 232275 | 23230 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 232389 | 23234 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 232400 | 23236 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 232411 | 23237 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 232422 | 23238 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 232433 | 23239 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 244591 | 23233 | 4 | 79.000 | A | 0.000 | A | M200 | 50.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 | |
| 230827 | 23116 | 5 | 0.000 | A | 0.000 | A | LED16.8 | 0.00 | 0.00 | 0 | 0.00 | 16.8W LED - 1600 Lumen | |
| 232269 | 23229 | 5 | 382.000 | A | 0.000 | A | PMDBSP8 | 0.00 | 0.00 | 0 | 0.00 | 8' Smooth Pole | |
| 232401 | 23236 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 232412 | 23237 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 232423 | 23238 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 232434 | 23239 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 232963 | 23268 | 5 | 0.000 | A | 0.000 | A | PMS | 0.00 | 0.00 | 0 | 0.00 | Single | |
| 232969 | 23270 | 5 | 0.000 | A | 0.000 | A | WHS14 | 0.00 | 0.00 | 0 | 0.00 | 14" Shade | |
| 244606 | 23240 | 5 | 17.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 244592 | 23233 | 6 | 79.000 | A | 0.000 | A | M305 | 50.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 244593 | 23233 | 8 | 79.000 | A | 0.000 | A | M603 | 50.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 | |
| 232270 | 23229 | 10 | 411.000 | A | 0.000 | A | PMDBFP8 | 0.00 | 0.00 | 0 | 0.00 | 8' Fluted Pole | |
| 232277 | 23230 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 232390 | 23234 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 232402 | 23236 | 10 | 10.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 232413 | 23237 | 10 | 10.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 232424 | 23238 | 10 | 10.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 232435 | 23239 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 232964 | 23268 | 10 | 97.000 | A | 0.000 | A | PMSD | 0.00 | 0.00 | 0 | 0.00 | Single Decorative | |
| 232970 | 23270 | 10 | 15.000 | A | 0.000 | A | WHS16 | 0.00 | 0.00 | 0 | 0.00 | 16" Shade | |
| 244594 | 23233 | 10 | 79.000 | A | 0.000 | A | M415 | 50.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 244607 | 23240 | 10 | 17.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 244595 | 23233 | 12 | 79.000 | A | 0.000 | A | M315 | 50.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 244596 | 23233 | 14 | 79.000 | A | 0.000 | A | M803 | 50.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 | |
| 232436 | 23239 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 234801 | 23410 | 15 | 0.000 | A | 0.000 | A | WGG | 0.00 | 0.00 | 0 | 0.00 | Wire Guard | |
| 244608 | 23240 | 15 | 17.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 244597 | 23233 | 16 | 79.000 | A | 0.000 | A | M210 | 50.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 223759 | 22644 | 20 | 0.000 | A | 0.000 | A | 4000K | 0.00 | 0.00 | 0 | 0.00 | 4000K - Cool White | |
| 232279 | 23230 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 232391 | 23234 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 232437 | 23239 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 234802 | 23410 | 20 | 0.000 | A | 0.000 | A | CGG | 0.00 | 0.00 | 0 | 0.00 | Cast Guard | |
| 244609 | 23240 | 20 | 17.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 232438 | 23239 | 25 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 234803 | 23410 | 25 | 0.000 | A | 0.000 | A | TGG | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty Guard | |
| 244610 | 23240 | 25 | 17.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 240467 | 23239 | 27 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 240468 | 23239 | 28 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 232439 | 23239 | 30 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 244611 | 23240 | 30 | 17.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 245146 | 23239 | 32 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 241151 | 23239 | 33 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 232440 | 23239 | 35 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 244612 | 23240 | 35 | 17.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 232441 | 23239 | 40 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 244613 | 23240 | 40 | 17.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 232442 | 23239 | 45 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 232443 | 23239 | 50 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 232357 | 23233 | 55 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 232444 | 23239 | 55 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 241152 | 23239 | 58 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 232358 | 23233 | 60 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 232445 | 23239 | 60 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 232359 | 23233 | 65 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 232446 | 23239 | 65 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 232360 | 23233 | 70 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 232447 | 23239 | 70 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 232361 | 23233 | 75 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 232448 | 23239 | 75 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 232362 | 23233 | 80 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 232449 | 23239 | 80 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 237026 | 23233 | 82 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 237027 | 23233 | 83 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 232363 | 23233 | 85 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 232450 | 23239 | 85 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 245142 | 23233 | 86 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 241146 | 23233 | 88 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 232364 | 23233 | 90 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 232451 | 23239 | 90 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 232365 | 23233 | 95 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 232452 | 23239 | 95 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241153 | 23239 | 98 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 232366 | 23233 | 100 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 232453 | 23239 | 100 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241154 | 23239 | 103 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 232367 | 23233 | 105 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 232454 | 23239 | 105 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 232368 | 23233 | 110 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 232455 | 23239 | 110 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 245147 | 23239 | 112 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 241147 | 23233 | 113 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 245148 | 23239 | 114 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 232369 | 23233 | 115 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 232456 | 23239 | 115 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 232370 | 23233 | 120 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 232457 | 23239 | 120 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 232371 | 23233 | 125 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 232458 | 23239 | 125 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 245149 | 23239 | 126 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241155 | 23239 | 128 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 232372 | 23233 | 130 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 232373 | 23233 | 135 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 232374 | 23233 | 140 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 232375 | 23233 | 145 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 232376 | 23233 | 150 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241148 | 23233 | 153 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 232377 | 23233 | 155 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241149 | 23233 | 158 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 232378 | 23233 | 160 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 232379 | 23233 | 165 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 245143 | 23233 | 166 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245144 | 23233 | 167 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 232388 | 23233 | 168 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 232380 | 23233 | 170 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 232381 | 23233 | 175 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 245145 | 23233 | 176 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241150 | 23233 | 178 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 232382 | 23233 | 180 | 160.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 0.00 | 995-Raw Copper | |
| 232383 | 23233 | 185 | 200.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 0.00 | 996-Weathered Copper | |
| 232384 | 23233 | 190 | 250.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 0.00 | 999-Oil-Rubbed Copper | |
| 232385 | 23233 | 195 | 210.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 232386 | 23233 | 200 | 250.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass |