{
"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 (23014,22394,23074,23015,24039,24041,23036,23037,23038,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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 221133 | 22394 | 0 | 0.000 | A | 0.000 | A | unselected | 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 | |
| 229895 | 23014 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 229899 | 23015 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230148 | 23036 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230159 | 23037 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230170 | 23038 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230513 | 23074 | 0 | 0.000 | A | 0.000 | A | unselected | 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 | |
| 245934 | 24039 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 246007 | 24041 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 245511 | 23014 | 2 | 79.000 | A | 0.000 | A | M103 | 50.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 245935 | 24039 | 2 | 0.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 229896 | 23015 | 3 | 0.000 | A | 0.000 | A | WGG | 0.00 | 0.00 | 0 | 0.00 | Wire Guard | |
| 230140 | 23036 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 230151 | 23037 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 230162 | 23038 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 245981 | 24041 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 245512 | 23014 | 4 | 79.000 | A | 0.000 | A | M200 | 50.00 | 0.00 | 0 | 0.00 | M200-White | |
| 245936 | 24039 | 4 | 0.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 221134 | 22394 | 5 | 0.000 | A | 0.000 | A | ST506 | 0.00 | 0.00 | 0 | 0.00 | 6" Stem - ½ Diameter | |
| 223756 | 22644 | 5 | 0.000 | A | 0.000 | A | 2700K | 0.00 | 0.00 | 0 | 0.00 | 2700K - Warm White/Soft White | |
| 229897 | 23015 | 5 | 5.000 | A | 0.000 | A | CGG | 0.00 | 0.00 | 0 | 1.29 | Cast Guard | |
| 230141 | 23036 | 5 | 80.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 230152 | 23037 | 5 | 80.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 230163 | 23038 | 5 | 80.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 230510 | 23074 | 5 | 0.000 | A | 0.000 | A | SC | 0.00 | 0.00 | 0 | 0.00 | Standard Canopy | |
| 230827 | 23116 | 5 | 0.000 | A | 0.000 | A | LED16.8 | 0.00 | 0.00 | 0 | 0.00 | 16.8W LED - 1600 Lumen | |
| 245982 | 24041 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 245513 | 23014 | 6 | 79.000 | A | 0.000 | A | M305 | 50.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 245937 | 24039 | 6 | 0.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 245514 | 23014 | 8 | 79.000 | A | 0.000 | A | M603 | 50.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 245938 | 24039 | 8 | 0.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 221135 | 22394 | 10 | 3.000 | A | 0.000 | A | ST512 | 0.00 | 0.00 | 0 | 0.00 | 12" Stem - ½ Diameter | |
| 223757 | 22644 | 10 | 0.000 | A | 0.000 | A | 3000K | 0.00 | 0.00 | 0 | 0.00 | 3000K - Neutral White | |
| 230142 | 23036 | 10 | 80.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 230153 | 23037 | 10 | 80.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 230164 | 23038 | 10 | 80.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 230511 | 23074 | 10 | 44.000 | A | 0.000 | A | HSC | 0.00 | 0.00 | 0 | 0.00 | 25° Hang Straight Canopy | |
| 245515 | 23014 | 10 | 79.000 | A | 0.000 | A | M415 | 50.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 245939 | 24039 | 10 | 0.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 245983 | 24041 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 245516 | 23014 | 12 | 79.000 | A | 0.000 | A | M315 | 50.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 245940 | 24039 | 12 | 0.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 245517 | 23014 | 14 | 79.000 | A | 0.000 | A | M803 | 50.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 245941 | 24039 | 14 | 0.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 221136 | 22394 | 15 | 5.000 | A | 0.000 | A | ST518 | 0.00 | 0.00 | 0 | 0.00 | 18" Stem - ½ Diameter | |
| 223758 | 22644 | 15 | 0.000 | A | 0.000 | A | 3500K | 0.00 | 0.00 | 0 | 0.00 | 3500K - Bright White | |
| 229898 | 23015 | 15 | 5.000 | A | 0.000 | A | TGG | 0.00 | 0.00 | 0 | 1.29 | Heavy Duty Guard | |
| 230512 | 23074 | 15 | 24.000 | A | 0.000 | A | HDSMC | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty Canopy | |
| 245984 | 24041 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 245518 | 23014 | 16 | 79.000 | A | 0.000 | A | M210 | 50.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 245942 | 24039 | 16 | 0.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 246006 | 24041 | 18 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 245999 | 24041 | 19 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 221137 | 22394 | 20 | 7.000 | A | 0.000 | A | ST524 | 0.00 | 0.00 | 0 | 0.00 | 24" Stem - ½ Diameter | |
| 223759 | 22644 | 20 | 0.000 | A | 0.000 | A | 4000K | 0.00 | 0.00 | 0 | 0.00 | 4000K - Cool White | |
| 246008 | 24041 | 21 | 0.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 246009 | 24041 | 22 | 0.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 229865 | 23014 | 24 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 245985 | 24041 | 24 | 0.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 221138 | 22394 | 25 | 12.000 | A | 0.000 | A | ST536 | 0.00 | 0.00 | 0 | 0.00 | 36" Stem - ½ Diameter | |
| 246015 | 24041 | 25 | 0.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 229866 | 23014 | 26 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 246010 | 24041 | 26 | 0.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 229867 | 23014 | 28 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 245986 | 24041 | 28 | 0.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 221139 | 22394 | 30 | 16.000 | A | 0.000 | A | ST548 | 0.00 | 0.00 | 0 | 0.00 | 48" Stem - ½ Diameter | |
| 229868 | 23014 | 30 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 245987 | 24041 | 30 | 0.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 229890 | 23014 | 32 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 229883 | 23014 | 34 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 245988 | 24041 | 35 | 0.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 237072 | 23014 | 36 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 4.50 | 106-Matte Black | |
| 237073 | 23014 | 38 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 4.50 | 206-Matte White | |
| 229869 | 23014 | 40 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 4.50 | 307-Emerald Green | |
| 245989 | 24041 | 40 | 0.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 241473 | 23014 | 42 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 4.50 | 320-Fern Green | |
| 229870 | 23014 | 44 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 4.50 | 370-Mint | |
| 245990 | 24041 | 45 | 0.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 229871 | 23014 | 46 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 4.50 | 380-Chartreuse | |
| 229872 | 23014 | 48 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 4.50 | 390-Teal | |
| 246011 | 24041 | 48 | 0.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 229873 | 23014 | 50 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 4.50 | 400-Barn Red | |
| 245991 | 24041 | 50 | 0.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 229874 | 23014 | 52 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 4.50 | 420-Orange | |
| 241474 | 23014 | 54 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 4.50 | 430-Soft Clay | |
| 245992 | 24041 | 55 | 0.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 229875 | 23014 | 56 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 4.50 | 470-Watermelon | |
| 229876 | 23014 | 58 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 4.50 | 480-Blush Pink | |
| 229877 | 23014 | 60 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 4.50 | 490-Magenta | |
| 245993 | 24041 | 60 | 0.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 229878 | 23014 | 65 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 4.50 | 495-Sherbet Orange | |
| 245994 | 24041 | 65 | 0.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 229879 | 23014 | 70 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 4.50 | 500-Buttery Yellow | |
| 245995 | 24041 | 70 | 0.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 229880 | 23014 | 75 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 4.50 | 570-Sunflower | |
| 245996 | 24041 | 75 | 0.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 229881 | 23014 | 80 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 4.50 | 600-Bronze | |
| 245997 | 24041 | 80 | 0.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 229882 | 23014 | 85 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 4.50 | 601-Chocolate | |
| 245998 | 24041 | 85 | 0.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241475 | 23014 | 88 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 4.50 | 607-Taupe | |
| 246012 | 24041 | 88 | 0.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 229884 | 23014 | 95 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 4.50 | 615-Oil-Rubbed Bronze | |
| 246000 | 24041 | 95 | 0.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241476 | 23014 | 98 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 4.50 | 630-Beige | |
| 246013 | 24041 | 98 | 0.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 229885 | 23014 | 100 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 4.50 | 700-Royal Blue | |
| 246001 | 24041 | 100 | 0.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 229886 | 23014 | 105 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 4.50 | 705-Navy | |
| 246002 | 24041 | 105 | 0.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 246016 | 24041 | 107 | 0.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 246017 | 24041 | 109 | 0.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 229887 | 23014 | 110 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 4.50 | 790-Lavender | |
| 246003 | 24041 | 110 | 0.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 229888 | 23014 | 115 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 4.50 | 800-Industrial Grey | |
| 246004 | 24041 | 115 | 0.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 229889 | 23014 | 120 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 4.50 | 805-Charcoal Granite | |
| 246005 | 24041 | 120 | 0.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 246018 | 24041 | 122 | 0.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241477 | 23014 | 123 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 4.50 | 815-Light Grey | |
| 246014 | 24041 | 123 | 0.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 242163 | 23014 | 126 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 4.50 | 311-Jadite | |
| 242164 | 23014 | 128 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 4.50 | 710-Cobalt Blue | |
| 242165 | 23014 | 130 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 4.50 | 715-Delphite Blue | |
| 242166 | 23014 | 132 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 4.50 | 810-Graphite |