{
"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": 131,
"filtered": 100,
"index_condition": "a.option_id in (22032,21970,23417,23418,22035,22650,22643,22644,22645) 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 | |
| 220111 | 22032 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220181 | 22035 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 223749 | 22643 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 223755 | 22644 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 223760 | 22645 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 223810 | 22650 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 234928 | 23417 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 234947 | 23418 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 217172 | 22032 | 1 | 0.000 | A | 0.000 | A | WHS24 | 0.00 | 0.00 | 0 | 0.00 | 24" Shade | |
| 234935 | 23418 | 1 | 4.000 | A | 0.000 | A | G1 | 0.00 | 0.00 | 0 | 0.00 | G1 Straight Arm | |
| 217173 | 22032 | 2 | 128.000 | A | 0.000 | A | WHS28 | 33.00 | 0.00 | 0 | 0.00 | 28" Shade | |
| 234936 | 23418 | 2 | 4.000 | A | 0.000 | A | G14 | 0.00 | 0.00 | 0 | 0.00 | G14 Straight Arm | |
| 215713 | 21970 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 217235 | 22035 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 21970 | 0.00 | Same as Shade | ||
| 223806 | 22650 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 234911 | 23417 | 4 | 12.000 | A | 0.000 | A | G11 | 0.00 | 0.00 | 0 | 0.00 | G11 Gooseneck Arm | |
| 234930 | 23418 | 4 | 12.000 | A | 0.000 | A | G11 | 0.00 | 0.00 | 0 | 0.00 | G11 Gooseneck Arm | |
| 215714 | 21970 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 217236 | 22035 | 5 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 223750 | 22643 | 5 | 0.000 | A | 0.000 | A | LED11 | 0.00 | 0.00 | 0 | 0.00 | 850 Lumens | |
| 223756 | 22644 | 5 | 0.000 | A | 0.000 | A | 2700K | 0.00 | 0.00 | 0 | 0.00 | 2700K - Warm White/Soft White | |
| 223761 | 22645 | 5 | 0.000 | A | 0.000 | A | DL | 0.00 | 0.00 | 0 | 0.00 | Domed Lens | |
| 223807 | 22650 | 5 | 43.000 | A | 0.000 | A | LDBPC | 0.00 | 0.00 | 0 | 11.00 | Decorative BP Cover | |
| 234912 | 23417 | 5 | 15.000 | A | 0.000 | A | G15 | 0.00 | 0.00 | 0 | 0.00 | G15 Gooseneck Arm | |
| 234931 | 23418 | 5 | 15.000 | A | 0.000 | A | G15 | 0.00 | 0.00 | 0 | 0.00 | G15 Gooseneck Arm | |
| 234913 | 23417 | 6 | 17.000 | A | 0.000 | A | G22 | 0.00 | 0.00 | 0 | 0.00 | G22 Gooseneck Arm | |
| 234932 | 23418 | 6 | 17.000 | A | 0.000 | A | G22 | 0.00 | 0.00 | 0 | 0.00 | G22 Gooseneck Arm | |
| 234918 | 23417 | 7 | 16.000 | A | 0.000 | A | G5 | 0.00 | 0.00 | 0 | 0.00 | G5 Gooseneck Arm | |
| 234937 | 23418 | 7 | 16.000 | A | 0.000 | A | G5 | 0.00 | 0.00 | 0 | 0.00 | G5 Gooseneck Arm | |
| 217264 | 22035 | 8 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 233533 | 22650 | 8 | 50.000 | A | 0.000 | A | LDCHX | 0.00 | 0.00 | 0 | 15.00 | Decorative BP & Hex Cover | |
| 234919 | 23417 | 8 | 21.000 | A | 0.000 | A | G25 | 0.00 | 0.00 | 0 | 0.00 | G25 Gooseneck Arm | |
| 234938 | 23418 | 8 | 21.000 | A | 0.000 | A | G25 | 0.00 | 0.00 | 0 | 0.00 | G25 Gooseneck Arm | |
| 234921 | 23417 | 9 | 158.000 | A | 0.000 | A | G64 | 0.00 | 0.00 | 0 | 0.00 | G64 Gooseneck Arm | |
| 234940 | 23418 | 9 | 158.000 | A | 0.000 | A | G64 | 0.00 | 0.00 | 0 | 0.00 | G64 Gooseneck Arm | |
| 215715 | 21970 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 217237 | 22035 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 223751 | 22643 | 10 | 0.000 | A | 0.000 | A | LED16 | 0.00 | 0.00 | 0 | 0.00 | 1250 Lumens | |
| 223757 | 22644 | 10 | 0.000 | A | 0.000 | A | 3000K | 0.00 | 0.00 | 0 | 0.00 | 3000K - Neutral White | |
| 223762 | 22645 | 10 | 0.000 | A | 0.000 | A | FL | 0.00 | 0.00 | 0 | 0.00 | Flat Lens | |
| 234914 | 23417 | 10 | 26.000 | A | 0.000 | A | G24 | 0.00 | 0.00 | 0 | 0.00 | G24 Gooseneck Arm | |
| 234933 | 23418 | 10 | 26.000 | A | 0.000 | A | G24 | 0.00 | 0.00 | 0 | 0.00 | G24 Gooseneck Arm | |
| 215716 | 21970 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 217238 | 22035 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 223752 | 22643 | 15 | 5.000 | A | 0.000 | A | LED27 | 0.00 | 0.00 | 0 | 1.25 | 2000 Lumens | |
| 223758 | 22644 | 15 | 0.000 | A | 0.000 | A | 3500K | 0.00 | 0.00 | 0 | 0.00 | 3500K - Bright White | |
| 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 | |
| 217239 | 22035 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 223753 | 22643 | 20 | 15.000 | A | 0.000 | A | LED38 | 0.00 | 0.00 | 0 | 3.75 | 3000 Lumens | |
| 223759 | 22644 | 20 | 0.000 | A | 0.000 | A | 4000K | 0.00 | 0.00 | 0 | 0.00 | 4000K - Cool White | |
| 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 | |
| 217240 | 22035 | 25 | 0.000 | A | 0.000 | A | 980 | 0.00 | 0.00 | 0 | 0.00 | 980-Brushed Aluminum | |
| 223754 | 22643 | 25 | 23.000 | A | 0.000 | A | LED43 | 0.00 | 0.00 | 0 | 5.75 | 4000 Lumens | |
| 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 | |
| 215718 | 21970 | 28 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 215719 | 21970 | 30 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 217241 | 22035 | 30 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 237038 | 22035 | 32 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 237039 | 22035 | 33 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 215720 | 21970 | 35 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 217242 | 22035 | 35 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 242657 | 22035 | 36 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 234922 | 23417 | 37 | 14.000 | A | 0.000 | A | G8 | 0.00 | 0.00 | 0 | 0.00 | G8 Gooseneck Arm | |
| 234941 | 23418 | 37 | 14.000 | A | 0.000 | A | G8 | 0.00 | 0.00 | 0 | 0.00 | G8 Gooseneck Arm | |
| 234926 | 23417 | 38 | 32.000 | A | 0.000 | A | G9 | 0.00 | 0.00 | 0 | 0.00 | G9 Gooseneck Arm | |
| 234945 | 23418 | 38 | 32.000 | A | 0.000 | A | G9 | 0.00 | 0.00 | 0 | 0.00 | G9 Gooseneck Arm | |
| 241261 | 22035 | 38 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 215721 | 21970 | 40 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 217243 | 22035 | 40 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 234923 | 23417 | 40 | 35.000 | A | 0.000 | A | G2 | 0.00 | 0.00 | 0 | 0.00 | G2 Gooseneck Arm | |
| 234942 | 23418 | 40 | 35.000 | A | 0.000 | A | G2 | 0.00 | 0.00 | 0 | 0.00 | G2 Gooseneck Arm | |
| 234915 | 23417 | 44 | 26.000 | A | 0.000 | A | G6 | 0.00 | 0.00 | 0 | 0.00 | G6 Gooseneck Arm | |
| 234934 | 23418 | 44 | 26.000 | A | 0.000 | A | G6 | 0.00 | 0.00 | 0 | 0.00 | G6 Gooseneck Arm | |
| 215722 | 21970 | 45 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 217244 | 22035 | 45 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 234920 | 23417 | 46 | 190.000 | A | 0.000 | A | G65 | 0.00 | 0.00 | 0 | 0.00 | G65 Gooseeneck Arm | |
| 234939 | 23418 | 46 | 190.000 | A | 0.000 | A | G65 | 0.00 | 0.00 | 0 | 0.00 | G65 Gooseeneck Arm | |
| 234924 | 23417 | 48 | 39.000 | A | 0.000 | A | G36 | 0.00 | 0.00 | 0 | 0.00 | G36 Gooseneck Arm | |
| 234943 | 23418 | 48 | 39.000 | A | 0.000 | A | G36 | 0.00 | 0.00 | 0 | 0.00 | G36 Gooseneck Arm | |
| 241142 | 21970 | 48 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 215723 | 21970 | 50 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 217245 | 22035 | 50 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 234925 | 23417 | 50 | 25.000 | A | 0.000 | A | G7 | 0.00 | 0.00 | 0 | 0.00 | G7 Gooseneck Arm | |
| 234944 | 23418 | 50 | 25.000 | A | 0.000 | A | G7 | 0.00 | 0.00 | 0 | 0.00 | G7 Gooseneck Arm | |
| 215724 | 21970 | 55 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 217246 | 22035 | 55 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 215725 | 21970 | 60 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 217247 | 22035 | 60 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 241262 | 22035 | 63 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 215726 | 21970 | 65 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 217248 | 22035 | 65 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 215727 | 21970 | 70 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 217249 | 22035 | 70 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 215728 | 21970 | 75 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 217250 | 22035 | 75 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 215729 | 21970 | 80 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 217251 | 22035 | 80 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 215730 | 21970 | 85 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 217252 | 22035 | 85 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 217253 | 22035 | 90 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 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 | |
| 217254 | 22035 | 95 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 241144 | 21970 | 98 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 215733 | 21970 | 100 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 217255 | 22035 | 100 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241263 | 22035 | 103 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 215734 | 21970 | 105 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 217256 | 22035 | 105 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241264 | 22035 | 108 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 215735 | 21970 | 110 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 217257 | 22035 | 110 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 242136 | 21970 | 112 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 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 | |
| 217258 | 22035 | 115 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 242658 | 22035 | 116 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242659 | 22035 | 117 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 243002 | 22035 | 118 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 230712 | 22035 | 119 | 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 | |
| 217259 | 22035 | 120 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 242660 | 22035 | 122 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241265 | 22035 | 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 |