{
"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": 238,
"filtered": 100,
"index_condition": "a.option_id in (22857,22858,22859,22860,22861,22862,22863,22864,22865,22872,22852,22873,22874,22875,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 | |
| 227161 | 22852 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227191 | 22857 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227194 | 22858 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227233 | 22859 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227263 | 22860 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227295 | 22861 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227330 | 22862 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227335 | 22863 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227336 | 22863 | 0 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | No Cap | |
| 227338 | 22864 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227339 | 22864 | 0 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | No Cap | |
| 227341 | 22865 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227342 | 22865 | 0 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | No Cap | |
| 227392 | 22872 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227397 | 22873 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227402 | 22874 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227407 | 22875 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 245559 | 22862 | 2 | 11.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 215376 | 21941 | 3 | 0.000 | A | 0.000 | A | E26 | 0.00 | 0.00 | 0 | 0.00 | E26 | |
| 227152 | 22852 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 227234 | 22860 | 3 | 11.000 | A | 0.000 | A | G26 | 0.00 | 0.00 | 0 | 0.00 | G26 Gooseneck Arm | |
| 227264 | 22861 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 22859 | 0.00 | Same as Shade | ||
| 227393 | 22873 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 227398 | 22874 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 227403 | 22875 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 245560 | 22862 | 4 | 11.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 215377 | 21941 | 5 | 14.000 | A | 0.000 | A | GU24 | 0.00 | 0.00 | 0 | 3.50 | GU24 | |
| 227153 | 22852 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 0.00 | Frosted Glass | |
| 227193 | 22857 | 5 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Standard Bulb E26/GU24 | ||
| 227195 | 22858 | 5 | 0.000 | A | 0.000 | A | ULM12 | 0.00 | 0.00 | 0 | 0.00 | 12" Shade | |
| 227235 | 22860 | 5 | 12.000 | A | 0.000 | A | G11 | 0.00 | 0.00 | 0 | 0.00 | G11 Gooseneck Arm | |
| 227337 | 22863 | 5 | 18.000 | A | 0.000 | A | CAP | 0.00 | 0.00 | 0 | 0.00 | With Cap | |
| 227340 | 22864 | 5 | 18.000 | A | 0.000 | A | CAP | 0.00 | 0.00 | 0 | 0.00 | With Cap | |
| 227343 | 22865 | 5 | 18.000 | A | 0.000 | A | CAP | 0.00 | 0.00 | 0 | 0.00 | With Cap | |
| 227394 | 22873 | 5 | 39.000 | A | 0.000 | A | DBPC | 0.00 | 0.00 | 0 | 0.00 | Decorative BP Cover | |
| 227399 | 22874 | 5 | 110.000 | A | 0.000 | A | DBPC | 0.00 | 0.00 | 0 | 0.00 | Copper BP Cover | |
| 227404 | 22875 | 5 | 121.000 | A | 0.000 | A | DBPC | 0.00 | 0.00 | 0 | 0.00 | Brass BP Cover | |
| 245561 | 22862 | 6 | 11.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 245562 | 22862 | 8 | 11.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 227154 | 22852 | 10 | 10.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 0.00 | Ribbed Glass | |
| 227192 | 22857 | 10 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Nautical LED | ||
| 227196 | 22858 | 10 | 18.000 | A | 0.000 | A | ULM14 | 0.00 | 0.00 | 0 | 0.00 | 14" Shade | |
| 227236 | 22860 | 10 | 15.000 | A | 0.000 | A | G15 | 0.00 | 0.00 | 0 | 0.00 | G15 Gooseneck Arm | |
| 227395 | 22873 | 10 | 92.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 0.00 | Dusk-to-Dawn Photocell | |
| 227400 | 22874 | 10 | 202.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 0.00 | Dusk-to-Dawn Photocell | |
| 227405 | 22875 | 10 | 213.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 0.00 | Dusk-to-Dawn Photocell | |
| 245563 | 22862 | 10 | 11.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 245564 | 22862 | 12 | 11.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 245565 | 22862 | 14 | 11.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 227197 | 22858 | 15 | 30.000 | A | 0.000 | A | ULM16 | 0.00 | 0.00 | 0 | 0.00 | 16" Shade | |
| 227237 | 22860 | 15 | 17.000 | A | 0.000 | A | G22 | 0.00 | 0.00 | 0 | 0.00 | G22 Gooseneck Arm | |
| 227396 | 22873 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty BP | |
| 227401 | 22874 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty BP | |
| 227406 | 22875 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 0.00 | Heavy Duty BP | |
| 245566 | 22862 | 16 | 11.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 227238 | 22860 | 20 | 14.000 | A | 0.000 | A | G8 | 0.00 | 0.00 | 0 | 0.00 | G8 Gooseneck Arm | |
| 227300 | 22862 | 20 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 227301 | 22862 | 22 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 227302 | 22862 | 24 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 227239 | 22860 | 25 | 26.000 | A | 0.000 | A | G24 | 0.00 | 0.00 | 0 | 0.00 | G24 Gooseneck Arm | |
| 227303 | 22862 | 26 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 227304 | 22862 | 28 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 227240 | 22860 | 30 | 26.000 | A | 0.000 | A | G6 | 0.00 | 0.00 | 0 | 0.00 | G6 Gooseneck Arm | |
| 227324 | 22862 | 30 | 0.000 | A | 0.000 | A | 980 | 0.00 | 0.00 | 0 | 0.00 | 980-Brushed Aluminum | |
| 227265 | 22861 | 34 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 227241 | 22860 | 35 | 0.000 | A | 0.000 | A | G3 | 0.00 | 0.00 | 0 | 0.00 | G3 Straight Arm | |
| 227266 | 22861 | 36 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 227267 | 22861 | 38 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 227362 | 22872 | 38 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 227198 | 22859 | 40 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 227242 | 22860 | 40 | 0.000 | A | 0.000 | A | G4 | 0.00 | 0.00 | 0 | 0.00 | G4 Straight Arm | |
| 227268 | 22861 | 40 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 227363 | 22872 | 40 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 227199 | 22859 | 42 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 227269 | 22861 | 42 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 227305 | 22862 | 42 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 227364 | 22872 | 42 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 227200 | 22859 | 44 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 227289 | 22861 | 44 | 0.000 | A | 0.000 | A | 980 | 0.00 | 0.00 | 0 | 0.00 | 980-Brushed Aluminum | |
| 227365 | 22872 | 44 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 237058 | 22862 | 44 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 227243 | 22860 | 45 | 4.000 | A | 0.000 | A | G1 | 0.00 | 0.00 | 0 | 0.00 | G1 Straight Arm | |
| 227201 | 22859 | 46 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 227270 | 22861 | 46 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 227366 | 22872 | 46 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 237059 | 22862 | 46 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 227202 | 22859 | 48 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 227306 | 22862 | 48 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 227367 | 22872 | 48 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 237056 | 22861 | 48 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 227203 | 22859 | 50 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 227244 | 22860 | 50 | 4.000 | A | 0.000 | A | G14 | 0.00 | 0.00 | 0 | 0.00 | G14 Straight Arm | |
| 237057 | 22861 | 50 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 237060 | 22872 | 50 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 242004 | 22862 | 50 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 227271 | 22861 | 52 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 227307 | 22862 | 52 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 237054 | 22859 | 52 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 237061 | 22872 | 52 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 227308 | 22862 | 54 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 227368 | 22872 | 54 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 237055 | 22859 | 54 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 241999 | 22861 | 54 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 227245 | 22860 | 55 | 2.000 | A | 0.000 | A | G16 | 0.00 | 0.00 | 0 | 0.00 | G16 Straight Arm | |
| 227204 | 22859 | 56 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 227272 | 22861 | 56 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 227309 | 22862 | 56 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 242744 | 22872 | 56 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 242736 | 22859 | 57 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 227273 | 22861 | 58 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 227310 | 22862 | 58 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 241974 | 22859 | 58 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 242009 | 22872 | 58 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 227205 | 22859 | 60 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 227246 | 22860 | 60 | 2.000 | A | 0.000 | A | G17 | 0.00 | 0.00 | 0 | 0.00 | G17 Straight Arm | |
| 227274 | 22861 | 60 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 227311 | 22862 | 60 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 227369 | 22872 | 60 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 227206 | 22859 | 62 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 227275 | 22861 | 62 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 227370 | 22872 | 62 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 242005 | 22862 | 63 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 227207 | 22859 | 64 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 227276 | 22861 | 64 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 227371 | 22872 | 64 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 227247 | 22860 | 65 | 26.000 | A | 0.000 | A | G35 | 0.00 | 0.00 | 0 | 0.00 | G35 Gooseneck Arm | |
| 227312 | 22862 | 65 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 227208 | 22859 | 66 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 227372 | 22872 | 66 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 242000 | 22861 | 66 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 227209 | 22859 | 68 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 227277 | 22861 | 68 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 227373 | 22872 | 68 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 227248 | 22860 | 70 | 30.000 | A | 0.000 | A | G34 | 0.00 | 0.00 | 0 | 0.00 | G34 Gooseneck Arm | |
| 227278 | 22861 | 70 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 227313 | 22862 | 70 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 241975 | 22859 | 70 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 242010 | 22872 | 70 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 227210 | 22859 | 72 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 227374 | 22872 | 72 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 227211 | 22859 | 74 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 227375 | 22872 | 74 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 227249 | 22860 | 75 | 16.000 | A | 0.000 | A | G5 | 0.00 | 0.00 | 0 | 0.00 | G5 Gooseneck Arm | |
| 227279 | 22861 | 75 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 227314 | 22862 | 75 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 227212 | 22859 | 76 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 227376 | 22872 | 76 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 227213 | 22859 | 78 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 227377 | 22872 | 78 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 227214 | 22859 | 80 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 227250 | 22860 | 80 | 21.000 | A | 0.000 | A | G25 | 0.00 | 0.00 | 0 | 0.00 | G25 Gooseneck Arm | |
| 227280 | 22861 | 80 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 227315 | 22862 | 80 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 227378 | 22872 | 80 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 227215 | 22859 | 85 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 227251 | 22860 | 85 | 28.000 | A | 0.000 | A | G10 | 0.00 | 0.00 | 0 | 0.00 | G10 Gooseneck Arm | |
| 227281 | 22861 | 85 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 227316 | 22862 | 85 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 227379 | 22872 | 85 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 227216 | 22859 | 90 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 227252 | 22860 | 90 | 97.000 | A | 0.000 | A | G19 | 0.00 | 0.00 | 0 | 0.00 | G19 Gooseneck Arm | |
| 227282 | 22861 | 90 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 227317 | 22862 | 90 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 227380 | 22872 | 90 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 227217 | 22859 | 95 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 227253 | 22860 | 95 | 190.000 | A | 0.000 | A | G65 | 0.00 | 0.00 | 0 | 0.00 | G65 Gooseneck Arm | |
| 227283 | 22861 | 95 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 227318 | 22862 | 95 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 227381 | 22872 | 95 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241976 | 22859 | 98 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 242011 | 22872 | 98 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 227218 | 22859 | 100 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 227254 | 22860 | 100 | 158.000 | A | 0.000 | A | G64 | 0.00 | 0.00 | 0 | 0.00 | G64 Gooseneck Arm | |
| 227284 | 22861 | 100 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 227319 | 22862 | 100 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 227382 | 22872 | 100 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241977 | 22859 | 103 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 242001 | 22861 | 103 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 242006 | 22862 | 103 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 242012 | 22872 | 103 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 227219 | 22859 | 105 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 227255 | 22860 | 105 | 8.000 | A | 0.000 | A | G12 | 0.00 | 0.00 | 0 | 0.00 | G12 Gooseneck Arm | |
| 227285 | 22861 | 105 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 227320 | 22862 | 105 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 227383 | 22872 | 105 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 242002 | 22861 | 106 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 242007 | 22862 | 108 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 227220 | 22859 | 110 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 227256 | 22860 | 110 | 10.000 | A | 0.000 | A | G13 | 0.00 | 0.00 | 0 | 0.00 | G13 Gooseneck Arm | |
| 227286 | 22861 | 110 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 227321 | 22862 | 110 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 227384 | 22872 | 110 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 242737 | 22859 | 112 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242745 | 22872 | 112 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242738 | 22859 | 113 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 242746 | 22872 | 113 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 227221 | 22859 | 115 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 227257 | 22860 | 115 | 23.000 | A | 0.000 | A | G32 | 0.00 | 0.00 | 0 | 0.00 | G32 Gooseneck Arm | |
| 227287 | 22861 | 115 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 227322 | 22862 | 115 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 227385 | 22872 | 115 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 0.00 | 790-Lavender | |
| 239946 | 22861 | 118 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 239947 | 22862 | 118 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 227222 | 22859 | 120 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 227258 | 22860 | 120 | 35.000 | A | 0.000 | A | G2 | 0.00 | 0.00 | 0 | 0.00 | G2 Gooseneck Arm | |
| 227288 | 22861 | 120 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 227323 | 22862 | 120 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 227386 | 22872 | 120 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 242003 | 22861 | 121 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 242008 | 22862 | 121 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 242839 | 22861 | 122 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 242843 | 22862 | 122 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 242840 | 22861 | 124 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 242844 | 22862 | 124 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 227223 | 22859 | 125 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 227259 | 22860 | 125 | 39.000 | A | 0.000 | A | G36 | 0.00 | 0.00 | 0 | 0.00 | G36 Gooseneck Arm | |
| 227387 | 22872 | 125 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 242739 | 22859 | 126 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 242747 | 22872 | 126 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 242841 | 22861 | 126 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 242845 | 22862 | 126 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 241978 | 22859 | 128 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 242013 | 22872 | 128 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Gray | |
| 242842 | 22861 | 128 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 242846 | 22862 | 128 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 227260 | 22860 | 130 | 25.000 | A | 0.000 | A | G7 | 0.00 | 0.00 | 0 | 0.00 | G7 Gooseneck Arm | |
| 227261 | 22860 | 135 | 32.000 | A | 0.000 | A | G9 | 0.00 | 0.00 | 0 | 0.00 | G9 Gooseneck Arm | |
| 227262 | 22860 | 140 | 141.000 | A | 0.000 | A | G40 | 0.00 | 0.00 | 0 | 0.00 | G40 Gooseneck Arm | |
| 227228 | 22859 | 150 | 160.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 0.00 | 995-Raw Copper | |
| 227328 | 22862 | 150 | 125.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 227229 | 22859 | 155 | 200.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 0.00 | 996-Weathered Copper | |
| 227329 | 22862 | 155 | 125.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass | |
| 227293 | 22861 | 158 | 125.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 227230 | 22859 | 160 | 250.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 0.00 | 999-Oil-Rubbed Copper | |
| 227294 | 22861 | 160 | 125.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass | |
| 227231 | 22859 | 165 | 210.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 227232 | 22859 | 170 | 250.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass |