{
"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": 134,
"filtered": 100,
"index_condition": "a.option_id in (22854,22847,21970,22850,22851,23766,22035,22903,23537,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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 218476 | 21970 | 0 | 0.000 | A | 0.000 | A | unselected | 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 | |
| 220318 | 21941 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227121 | 22847 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227138 | 22850 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227145 | 22851 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227177 | 22854 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227972 | 22903 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 236827 | 23537 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 239756 | 23766 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 229864 | 22903 | 2 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 215376 | 21941 | 3 | 0.000 | A | 0.000 | A | E26 | 0.00 | 0.00 | 0 | 0.00 | E26 | |
| 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 | ||
| 227963 | 22903 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 236823 | 23537 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 239727 | 23766 | 3 | 11.000 | A | 0.000 | A | G26 | 0.00 | 0.00 | 0 | 0.00 | G26 Gooseneck Arm | |
| 215377 | 21941 | 5 | 14.000 | A | 0.000 | A | GU24 | 0.00 | 0.00 | 0 | 3.50 | GU24 | |
| 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 | |
| 227122 | 22847 | 5 | 0.000 | A | 0.000 | A | SML | 0.00 | 0.00 | 0 | 0.00 | Small Cylinder | |
| 227139 | 22850 | 5 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | No Slot | |
| 227146 | 22851 | 5 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | No Slot | |
| 227178 | 22854 | 5 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Standard Bulb E26/GU24 | ||
| 227964 | 22903 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 236824 | 23537 | 5 | 43.000 | A | 0.000 | A | DBPC | 0.00 | 0.00 | 0 | 0.00 | Decorative BP Cover | |
| 239728 | 23766 | 5 | 12.000 | A | 0.000 | A | G11 | 0.00 | 0.00 | 0 | 0.00 | G11 Gooseneck Arm | |
| 217264 | 22035 | 8 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 236828 | 23537 | 8 | 61.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 0.00 | Decorative BP & Hex Cover | |
| 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 | |
| 227123 | 22847 | 10 | 18.000 | A | 0.000 | A | LRG | 0.00 | 0.00 | 0 | 0.00 | Large Cylinder | |
| 227140 | 22850 | 10 | 7.000 | A | 0.000 | A | SND | 0.00 | 0.00 | 0 | 0.00 | Single Standard Slot | |
| 227147 | 22851 | 10 | 7.000 | A | 0.000 | A | SND | 0.00 | 0.00 | 0 | 0.00 | Single Standard Slot | |
| 227179 | 22854 | 10 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Integrated LED | ||
| 227965 | 22903 | 10 | 10.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 236825 | 23537 | 10 | 92.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 0.00 | Dusk-to-Dawn Photocell | |
| 239729 | 23766 | 10 | 15.000 | A | 0.000 | A | G15 | 0.00 | 0.00 | 0 | 0.00 | G15 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 | |
| 236826 | 23537 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty BP | |
| 239730 | 23766 | 15 | 17.000 | A | 0.000 | A | G22 | 0.00 | 0.00 | 0 | 0.00 | G22 Gooseneck Arm | |
| 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 | |
| 239731 | 23766 | 20 | 14.000 | A | 0.000 | A | G8 | 0.00 | 0.00 | 0 | 0.00 | G8 Gooseneck Arm | |
| 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 | |
| 239732 | 23766 | 25 | 26.000 | A | 0.000 | A | G24 | 0.00 | 0.00 | 0 | 0.00 | G24 Gooseneck Arm | |
| 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 | |
| 239733 | 23766 | 30 | 26.000 | A | 0.000 | A | G6 | 0.00 | 0.00 | 0 | 0.00 | G6 Gooseneck Arm | |
| 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 | |
| 239734 | 23766 | 35 | 0.000 | A | 0.000 | A | G3 | 0.00 | 0.00 | 0 | 0.00 | G3 Straight Arm | |
| 242657 | 22035 | 36 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 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 | |
| 239735 | 23766 | 40 | 0.000 | A | 0.000 | A | G4 | 0.00 | 0.00 | 0 | 0.00 | G4 Straight 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 | |
| 239736 | 23766 | 45 | 4.000 | A | 0.000 | A | G1 | 0.00 | 0.00 | 0 | 0.00 | G1 Straight 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 | |
| 239737 | 23766 | 50 | 4.000 | A | 0.000 | A | G14 | 0.00 | 0.00 | 0 | 0.00 | G14 Straight 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 | |
| 239738 | 23766 | 55 | 2.000 | A | 0.000 | A | G16 | 0.00 | 0.00 | 0 | 0.00 | G16 Straight Arm | |
| 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 | |
| 239739 | 23766 | 60 | 2.000 | A | 0.000 | A | G17 | 0.00 | 0.00 | 0 | 0.00 | G17 Straight Arm | |
| 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 | |
| 239740 | 23766 | 65 | 26.000 | A | 0.000 | A | G35 | 0.00 | 0.00 | 0 | 0.00 | G35 Gooseneck Arm | |
| 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 | |
| 239741 | 23766 | 70 | 30.000 | A | 0.000 | A | G34 | 0.00 | 0.00 | 0 | 0.00 | G34 Gooseneck Arm | |
| 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 | |
| 239742 | 23766 | 75 | 16.000 | A | 0.000 | A | G5 | 0.00 | 0.00 | 0 | 0.00 | G5 Gooseneck Arm | |
| 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 | |
| 239743 | 23766 | 80 | 21.000 | A | 0.000 | A | G25 | 0.00 | 0.00 | 0 | 0.00 | G25 Gooseneck Arm | |
| 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 | |
| 239744 | 23766 | 85 | 28.000 | A | 0.000 | A | G10 | 0.00 | 0.00 | 0 | 0.00 | G10 Gooseneck Arm | |
| 217253 | 22035 | 90 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 239745 | 23766 | 90 | 97.000 | A | 0.000 | A | G19 | 0.00 | 0.00 | 0 | 0.00 | G19 Gooseneck Arm | |
| 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 | |
| 239746 | 23766 | 95 | 190.000 | A | 0.000 | A | G65 | 0.00 | 0.00 | 0 | 0.00 | G65 Gooseneck Arm | |
| 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 | |
| 239747 | 23766 | 100 | 158.000 | A | 0.000 | A | G64 | 0.00 | 0.00 | 0 | 0.00 | G64 Gooseneck Arm | |
| 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 | |
| 239748 | 23766 | 105 | 8.000 | A | 0.000 | A | G12 | 0.00 | 0.00 | 0 | 0.00 | G12 Gooseneck Arm | |
| 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 | |
| 239749 | 23766 | 110 | 10.000 | A | 0.000 | A | G13 | 0.00 | 0.00 | 0 | 0.00 | G13 Gooseneck Arm | |
| 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 | |
| 239750 | 23766 | 115 | 23.000 | A | 0.000 | A | G32 | 0.00 | 0.00 | 0 | 0.00 | G32 Gooseneck Arm | |
| 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 | |
| 239751 | 23766 | 120 | 35.000 | A | 0.000 | A | G2 | 0.00 | 0.00 | 0 | 0.00 | G2 Gooseneck Arm | |
| 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 | |
| 239752 | 23766 | 125 | 39.000 | A | 0.000 | A | G36 | 0.00 | 0.00 | 0 | 0.00 | G36 Gooseneck Arm | |
| 241145 | 21970 | 125 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 239753 | 23766 | 130 | 25.000 | A | 0.000 | A | G7 | 0.00 | 0.00 | 0 | 0.00 | G7 Gooseneck Arm | |
| 239754 | 23766 | 135 | 32.000 | A | 0.000 | A | G9 | 0.00 | 0.00 | 0 | 0.00 | G9 Gooseneck Arm | |
| 239755 | 23766 | 140 | 141.000 | A | 0.000 | A | G40 | 0.00 | 0.00 | 0 | 0.00 | G40 Gooseneck Arm |