{
"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": 121,
"filtered": 100,
"index_condition": "a.option_id in (22929,22791,22930,22931,22932,22798,22799,22800,22801,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 | |
| 226373 | 22791 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 226485 | 22798 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 226490 | 22799 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 226495 | 22800 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 226500 | 22801 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 228305 | 22929 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 228337 | 22930 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 228338 | 22931 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 228343 | 22932 | 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 | |
| 226338 | 22791 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 226486 | 22799 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 226491 | 22800 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 226496 | 22801 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 228308 | 22930 | 3 | 11.000 | A | 0.000 | A | G26 | 0.00 | 0.00 | 0 | 0.00 | G26 Gooseneck Arm | |
| 228342 | 22931 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 228347 | 22932 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 215377 | 21941 | 5 | 14.000 | A | 0.000 | A | GU24 | 0.00 | 0.00 | 0 | 3.50 | GU24 | |
| 226339 | 22791 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 226455 | 22798 | 5 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 226487 | 22799 | 5 | 39.000 | A | 0.000 | A | DBPC | 0.00 | 0.00 | 0 | 0.00 | Decorative BP Cover | |
| 226492 | 22800 | 5 | 110.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 0.00 | Copper BP & Hex Cover | |
| 226497 | 22801 | 5 | 121.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 0.00 | Brass BP & Hex Cover | |
| 228306 | 22929 | 5 | 0.000 | A | 0.000 | A | DRM | 0.00 | 0.00 | 0 | 0.00 | Opaque Glass | |
| 228309 | 22930 | 5 | 12.000 | A | 0.000 | A | G11 | 0.00 | 0.00 | 0 | 0.00 | G11 Gooseneck Arm | |
| 228339 | 22931 | 5 | 30.000 | A | 0.000 | A | PB7 | 0.00 | 0.00 | 0 | 0.00 | PB7 - Single Painted Band | |
| 228344 | 22932 | 5 | 30.000 | A | 0.000 | A | PB7 | 0.00 | 0.00 | 0 | 0.00 | PB7 - Single Painted Band | |
| 233539 | 22799 | 8 | 61.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 0.00 | Decorative BP & Hex Cover | |
| 226340 | 22791 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 226488 | 22799 | 10 | 92.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 0.00 | Dusk-to-Dawn Photocell | |
| 226493 | 22800 | 10 | 202.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 0.00 | Dusk-to-Dawn Photocell | |
| 226498 | 22801 | 10 | 213.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 0.00 | Dusk-to-Dawn Photocell | |
| 228307 | 22929 | 10 | 0.000 | A | 0.000 | A | DRMCL | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 228310 | 22930 | 10 | 15.000 | A | 0.000 | A | G15 | 0.00 | 0.00 | 0 | 0.00 | G15 Gooseneck Arm | |
| 228340 | 22931 | 10 | 30.000 | A | 0.000 | A | PB8 | 0.00 | 0.00 | 0 | 0.00 | PB8 - Four Painted Band | |
| 228345 | 22932 | 10 | 30.000 | A | 0.000 | A | PB8 | 0.00 | 0.00 | 0 | 0.00 | PB8 - Four Painted Band | |
| 226341 | 22791 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 226457 | 22798 | 15 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 226489 | 22799 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty BP | |
| 226494 | 22800 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty BP | |
| 226499 | 22801 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty BP | |
| 228311 | 22930 | 15 | 17.000 | A | 0.000 | A | G22 | 0.00 | 0.00 | 0 | 0.00 | G22 Gooseneck Arm | |
| 228341 | 22931 | 15 | 30.000 | A | 0.000 | A | PB9 | 0.00 | 0.00 | 0 | 0.00 | PB9 - Seven Painted Band | |
| 228346 | 22932 | 15 | 30.000 | A | 0.000 | A | PB9 | 0.00 | 0.00 | 0 | 0.00 | PB9 - Seven Painted Band | |
| 228331 | 22930 | 18 | 14.000 | A | 0.000 | A | G8 | 0.00 | 0.00 | 0 | 0.00 | G8 Gooseneck Arm | |
| 226342 | 22791 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 228312 | 22930 | 20 | 26.000 | A | 0.000 | A | G24 | 0.00 | 0.00 | 0 | 0.00 | G24 Gooseneck Arm | |
| 226343 | 22791 | 25 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 228313 | 22930 | 25 | 26.000 | A | 0.000 | A | G6 | 0.00 | 0.00 | 0 | 0.00 | G6 Gooseneck Arm | |
| 237048 | 22791 | 27 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 237049 | 22791 | 28 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 226344 | 22791 | 30 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 228314 | 22930 | 30 | 0.000 | A | 0.000 | A | G3 | 0.00 | 0.00 | 0 | 0.00 | G3 Straight Arm | |
| 241325 | 22791 | 33 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 226345 | 22791 | 35 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 228315 | 22930 | 35 | 0.000 | A | 0.000 | A | G4 | 0.00 | 0.00 | 0 | 0.00 | G4 Straight Arm | |
| 226346 | 22791 | 40 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 226462 | 22798 | 40 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 228316 | 22930 | 40 | 4.000 | A | 0.000 | A | G1 | 0.00 | 0.00 | 0 | 0.00 | G1 Straight Arm | |
| 226347 | 22791 | 45 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 228317 | 22930 | 45 | 4.000 | A | 0.000 | A | G14 | 0.00 | 0.00 | 0 | 0.00 | G14 Straight Arm | |
| 226348 | 22791 | 50 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 226481 | 22798 | 50 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 228318 | 22930 | 50 | 2.000 | A | 0.000 | A | G16 | 0.00 | 0.00 | 0 | 0.00 | G16 Straight Arm | |
| 244281 | 22798 | 53 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 226349 | 22791 | 55 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 226465 | 22798 | 55 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 228319 | 22930 | 55 | 2.000 | A | 0.000 | A | G17 | 0.00 | 0.00 | 0 | 0.00 | G17 Straight Arm | |
| 241326 | 22791 | 58 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 226350 | 22791 | 60 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 226466 | 22798 | 60 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 228320 | 22930 | 60 | 26.000 | A | 0.000 | A | G35 | 0.00 | 0.00 | 0 | 0.00 | G35 Gooseneck Arm | |
| 226351 | 22791 | 65 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 228321 | 22930 | 65 | 30.000 | A | 0.000 | A | G34 | 0.00 | 0.00 | 0 | 0.00 | G34 Gooseneck Arm | |
| 244282 | 22798 | 65 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 226352 | 22791 | 70 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 228322 | 22930 | 70 | 16.000 | A | 0.000 | A | G5 | 0.00 | 0.00 | 0 | 0.00 | G5 Gooseneck Arm | |
| 239948 | 22798 | 70 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 226353 | 22791 | 75 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 228323 | 22930 | 75 | 21.000 | A | 0.000 | A | G25 | 0.00 | 0.00 | 0 | 0.00 | G25 Gooseneck Arm | |
| 226354 | 22791 | 80 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 226470 | 22798 | 80 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 228324 | 22930 | 80 | 28.000 | A | 0.000 | A | G10 | 0.00 | 0.00 | 0 | 0.00 | G10 Gooseneck Arm | |
| 226355 | 22791 | 85 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 228325 | 22930 | 85 | 97.000 | A | 0.000 | A | G19 | 0.00 | 0.00 | 0 | 0.00 | G19 Gooseneck Arm | |
| 226356 | 22791 | 90 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 226472 | 22798 | 90 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 228326 | 22930 | 90 | 190.000 | A | 0.000 | A | G65 | 0.00 | 0.00 | 0 | 0.00 | G65 Gooseneck Arm | |
| 226357 | 22791 | 95 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 228327 | 22930 | 95 | 158.000 | A | 0.000 | A | G64 | 0.00 | 0.00 | 0 | 0.00 | G64 Gooseneck Arm | |
| 241327 | 22791 | 98 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 226358 | 22791 | 100 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Textured Bronze | |
| 226474 | 22798 | 100 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 228328 | 22930 | 100 | 8.000 | A | 0.000 | A | G12 | 0.00 | 0.00 | 0 | 0.00 | G12 Gooseneck Arm | |
| 241328 | 22791 | 103 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 226359 | 22791 | 105 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 228329 | 22930 | 105 | 10.000 | A | 0.000 | A | G13 | 0.00 | 0.00 | 0 | 0.00 | G13 Gooseneck Arm | |
| 226360 | 22791 | 110 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 228330 | 22930 | 110 | 23.000 | A | 0.000 | A | G32 | 0.00 | 0.00 | 0 | 0.00 | G32 Gooseneck Arm | |
| 226361 | 22791 | 115 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 226477 | 22798 | 115 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 226362 | 22791 | 120 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 226478 | 22798 | 120 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 228332 | 22930 | 120 | 35.000 | A | 0.000 | A | G2 | 0.00 | 0.00 | 0 | 0.00 | G2 Gooseneck Arm | |
| 226483 | 22798 | 123 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite | |
| 226363 | 22791 | 125 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 228333 | 22930 | 125 | 39.000 | A | 0.000 | A | G36 | 0.00 | 0.00 | 0 | 0.00 | G36 Gooseneck Arm | |
| 241329 | 22791 | 128 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 228334 | 22930 | 130 | 25.000 | A | 0.000 | A | G7 | 0.00 | 0.00 | 0 | 0.00 | G7 Gooseneck Arm | |
| 242533 | 22791 | 130 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 242534 | 22791 | 132 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242535 | 22791 | 134 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 228335 | 22930 | 135 | 32.000 | A | 0.000 | A | G9 | 0.00 | 0.00 | 0 | 0.00 | G9 Gooseneck Arm | |
| 242536 | 22791 | 136 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 228336 | 22930 | 140 | 141.000 | A | 0.000 | A | G40 | 0.00 | 0.00 | 0 | 0.00 | G40 Gooseneck Arm | |
| 226368 | 22791 | 150 | 238.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 0.00 | 995-Raw Copper | |
| 226369 | 22791 | 155 | 267.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 0.00 | 996-Weathered Copper | |
| 226370 | 22791 | 160 | 267.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 0.00 | 999-Oil-Rubbed Copper | |
| 226371 | 22791 | 165 | 267.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 226372 | 22791 | 170 | 295.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass |