{
"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": 279,
"filtered": 100,
"index_condition": "a.option_id in (21926,21927,21929,21930,21931,22012,22659,23328,21935,21934,21933,21936,21937,21974,21975,22052,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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 220109 | 21929 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220123 | 21926 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220140 | 21927 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220190 | 21930 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220191 | 21931 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220199 | 22012 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220255 | 21933 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220256 | 21934 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220257 | 21935 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220286 | 21937 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220296 | 22052 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220301 | 21974 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220302 | 21975 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220414 | 21936 | 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 | |
| 223933 | 22659 | 0 | 0.000 | A | 0.000 | A | skip | 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 | |
| 233546 | 23328 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 215185 | 21929 | 1 | 11.000 | A | 0.000 | A | G26 | 0.00 | 0.00 | 0 | 2.62 | G26 Gooseneck Arm | |
| 233545 | 22659 | 2 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 6.25 | No Guard | |
| 244494 | 21927 | 2 | 79.000 | A | 0.000 | A | M103 | 50.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 244510 | 21937 | 2 | 0.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 215103 | 21926 | 3 | 0.000 | A | 0.000 | A | WHS12 | 0.00 | 0.00 | 0 | 0.00 | 12" Shade | |
| 215214 | 21930 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 21927 | 0.00 | Same as Shade | ||
| 215245 | 21931 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 21927 | 0.00 | Same as Shade | ||
| 215265 | 21933 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 215275 | 21934 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 215285 | 21935 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 215295 | 21936 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 215814 | 21974 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 215818 | 21975 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 216905 | 22012 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 217544 | 22052 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 223930 | 22659 | 3 | 0.000 | A | 0.000 | A | WGG | 0.00 | 0.00 | 0 | 16.34 | Wire Guard | |
| 244511 | 21937 | 4 | 0.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 244534 | 21931 | 4 | 11.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 215104 | 21926 | 5 | 14.000 | A | 0.000 | A | WHS14 | 0.00 | 0.00 | 0 | 3.33 | 14" Shade | |
| 215186 | 21929 | 5 | 12.000 | A | 0.000 | A | G11 | 0.00 | 0.00 | 0 | 2.90 | G11 Gooseneck Arm | |
| 215215 | 21930 | 5 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 215266 | 21933 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 1.88 | Frosted Glass | |
| 215276 | 21934 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 1.88 | Frosted Glass | |
| 215286 | 21935 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 1.88 | Frosted Glass | |
| 215296 | 21936 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 215817 | 21974 | 5 | 110.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 30.00 | Copper BP & Hex Cover | |
| 215821 | 21975 | 5 | 121.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 30.00 | Brass BP & Hex Cover | |
| 216906 | 22012 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 217545 | 22052 | 5 | 43.000 | A | 0.000 | A | DBPC | 0.00 | 0.00 | 0 | {} | 11.00 | Decorative BP Cover |
| 223756 | 22644 | 5 | 0.000 | A | 0.000 | A | 2700K | 0.00 | 0.00 | 0 | 0.00 | 2700K - Warm White/Soft White | |
| 223931 | 22659 | 5 | 0.000 | A | 0.000 | A | CGG | 0.00 | 0.00 | 0 | 1.50 | Cast Guard | |
| 230827 | 23116 | 5 | 0.000 | A | 0.000 | A | LED16.8 | 0.00 | 0.00 | 0 | 0.00 | 16.8W LED - 1600 Lumen | |
| 233547 | 23328 | 5 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 2.85 | Clear Glass | |
| 244495 | 21927 | 5 | 79.000 | A | 0.000 | A | M200 | 50.00 | 0.00 | 0 | 0.00 | M200-White | |
| 244512 | 21937 | 6 | 0.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 244535 | 21931 | 6 | 11.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 233532 | 22052 | 8 | 50.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 15.00 | Decorative BP & Hex Cover | |
| 244513 | 21937 | 8 | 0.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 244536 | 21931 | 8 | 11.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 215105 | 21926 | 10 | 29.000 | A | 0.000 | A | WHS16 | 0.00 | 0.00 | 0 | 7.05 | 16" Shade | |
| 215187 | 21929 | 10 | 15.000 | A | 0.000 | A | G15 | 0.00 | 0.00 | 0 | 3.63 | G15 Gooseneck Arm | |
| 215216 | 21930 | 10 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 215267 | 21933 | 10 | 13.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 3.15 | Ribbed Glass | |
| 215277 | 21934 | 10 | 13.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 3.15 | Ribbed Glass | |
| 215287 | 21935 | 10 | 13.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 3.15 | Ribbed Glass | |
| 215297 | 21936 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 215815 | 21974 | 10 | 202.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 32.00 | Dusk-to-Dawn Photocell | |
| 215819 | 21975 | 10 | 213.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 32.00 | Dusk-to-Dawn Photocell | |
| 216907 | 22012 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 217546 | 22052 | 10 | 92.000 | A | 0.000 | A | DD | 0.00 | 0.00 | 0 | 23.00 | Dusk-to-Dawn Photocell | |
| 223757 | 22644 | 10 | 0.000 | A | 0.000 | A | 3000K | 0.00 | 0.00 | 0 | 0.00 | 3000K - Neutral White | |
| 233548 | 23328 | 10 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 1.88 | Frosted Glass | |
| 244496 | 21927 | 10 | 79.000 | A | 0.000 | A | M305 | 50.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 244514 | 21937 | 10 | 0.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 244537 | 21931 | 10 | 11.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 244515 | 21937 | 12 | 0.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 244538 | 21931 | 12 | 11.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 244516 | 21937 | 14 | 0.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 244539 | 21931 | 14 | 11.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 215106 | 21926 | 15 | 46.000 | A | 0.000 | A | WHS18 | 0.00 | 0.00 | 0 | 11.44 | 18" Shade | |
| 215188 | 21929 | 15 | 17.000 | A | 0.000 | A | G22 | 0.00 | 0.00 | 0 | 4.25 | G22 Gooseneck Arm | |
| 215217 | 21930 | 15 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 215298 | 21936 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 215816 | 21974 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 8.92 | Heavy Duty BP | |
| 215820 | 21975 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 8.92 | Heavy Duty BP | |
| 216908 | 22012 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 217547 | 22052 | 15 | 83.000 | A | 0.000 | A | HDBP | 0.00 | 0.00 | 0 | 20.75 | Heavy Duty BP | |
| 223758 | 22644 | 15 | 0.000 | A | 0.000 | A | 3500K | 0.00 | 0.00 | 0 | 0.00 | 3500K - Bright White | |
| 223932 | 22659 | 15 | 0.000 | A | 0.000 | A | TGG | 0.00 | 0.00 | 0 | 1.50 | Heavy Duty Guard | |
| 233549 | 23328 | 15 | 10.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 3.15 | Ribbed Glass | |
| 244497 | 21927 | 15 | 79.000 | A | 0.000 | A | M603 | 50.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 244517 | 21937 | 16 | 0.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 244540 | 21931 | 16 | 11.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 215208 | 21929 | 18 | 14.000 | A | 0.000 | A | G8 | 0.00 | 0.00 | 0 | 3.36 | G8 Gooseneck Arm | |
| 244541 | 21931 | 18 | 11.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 215107 | 21926 | 20 | 67.000 | A | 0.000 | A | WHS20 | 0.00 | 0.00 | 0 | 16.69 | 20" Shade | |
| 215189 | 21929 | 20 | 26.000 | A | 0.000 | A | G24 | 0.00 | 0.00 | 0 | 6.27 | G24 Gooseneck Arm | |
| 215218 | 21930 | 20 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 215299 | 21936 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 216909 | 22012 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 223759 | 22644 | 20 | 0.000 | A | 0.000 | A | 4000K | 0.00 | 0.00 | 0 | 0.00 | 4000K - Cool White | |
| 244498 | 21927 | 20 | 79.000 | A | 0.000 | A | M415 | 50.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 215190 | 21929 | 25 | 26.000 | A | 0.000 | A | G6 | 0.00 | 0.00 | 0 | 6.46 | G6 Gooseneck Arm | |
| 215219 | 21930 | 25 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 215300 | 21936 | 25 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 216910 | 22012 | 25 | 0.000 | A | 0.000 | A | 980 | 0.00 | 0.00 | 0 | 0.00 | 980-Brushed Aluminum | |
| 243000 | 21926 | 25 | 385.000 | A | 0.000 | A | WHS24 | 0.00 | 0.00 | 0 | 29.00 | 24" Shade | |
| 244499 | 21927 | 25 | 79.000 | A | 0.000 | A | M315 | 50.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 236852 | 21936 | 27 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 2.75 | 106-Matte Black | |
| 215239 | 21930 | 28 | 0.000 | A | 0.000 | A | 980 | 0.00 | 0.00 | 0 | 0.00 | 980-Brushed Aluminum | |
| 236853 | 21936 | 28 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 2.75 | 206-Matte White | |
| 215191 | 21929 | 30 | 0.000 | A | 0.000 | A | G3 | 0.00 | 0.00 | 0 | 0.00 | G3 Straight Arm | |
| 215220 | 21930 | 30 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 215301 | 21936 | 30 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 2.75 | 307-Emerald Green | |
| 216911 | 22012 | 30 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 243001 | 21926 | 30 | 513.000 | A | 0.000 | A | WHS28 | 0.00 | 0.00 | 0 | 40.00 | 28" Shade | |
| 244500 | 21927 | 30 | 79.000 | A | 0.000 | A | M803 | 50.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 236848 | 21930 | 32 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 4.50 | 106-Matte Black | |
| 236850 | 22012 | 32 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 4.50 | 106-Matte Black | |
| 245098 | 21936 | 32 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 240955 | 21936 | 33 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 2.75 | 320-Fern Green | |
| 236849 | 21930 | 34 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 4.50 | 206-Matte White | |
| 236851 | 22012 | 34 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 4.50 | 206-Matte White | |
| 215192 | 21929 | 35 | 0.000 | A | 0.000 | A | G4 | 0.00 | 0.00 | 0 | 0.00 | G4 Straight Arm | |
| 215221 | 21930 | 35 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 2.75 | 307-Emerald Green | |
| 215302 | 21936 | 35 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 2.75 | 370-Mint | |
| 216912 | 22012 | 35 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 2.75 | 307-Emerald Green | |
| 244501 | 21927 | 35 | 79.000 | A | 0.000 | A | M210 | 50.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 245110 | 21930 | 36 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 245114 | 22012 | 36 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 240945 | 21930 | 38 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 2.75 | 320-Fern Green | |
| 240950 | 22012 | 38 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 2.75 | 320-Fern Green | |
| 215193 | 21929 | 40 | 4.000 | A | 0.000 | A | G1 | 0.00 | 0.00 | 0 | 0.83 | G1 Straight Arm | |
| 215222 | 21930 | 40 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 2.75 | 370-Mint | |
| 215303 | 21936 | 40 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 2.75 | 380-Chartreuse | |
| 216913 | 22012 | 40 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 2.75 | 370-Mint | |
| 215194 | 21929 | 45 | 4.000 | A | 0.000 | A | G14 | 0.00 | 0.00 | 0 | 2.60 | G14 Straight Arm | |
| 215223 | 21930 | 45 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 2.75 | 380-Chartreuse | |
| 215304 | 21936 | 45 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 2.75 | 390-Teal | |
| 216914 | 22012 | 45 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 2.75 | 380-Chartreuse | |
| 215195 | 21929 | 50 | 2.000 | A | 0.000 | A | G16 | 0.00 | 0.00 | 0 | 0.38 | G16 Straight Arm | |
| 215224 | 21930 | 50 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 2.75 | 390-Teal | |
| 215305 | 21936 | 50 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 2.75 | 400-Barn Red | |
| 216915 | 22012 | 50 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 2.75 | 390-Teal | |
| 215119 | 21927 | 55 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 215196 | 21929 | 55 | 2.000 | A | 0.000 | A | G17 | 0.00 | 0.00 | 0 | 0.49 | G17 Straight Arm | |
| 215225 | 21930 | 55 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 2.75 | 400-Barn Red | |
| 215306 | 21936 | 55 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 2.75 | 420-Orange | |
| 216916 | 22012 | 55 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 2.75 | 400-Barn Red | |
| 240956 | 21936 | 58 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 2.75 | 430-Soft Clay | |
| 215120 | 21927 | 60 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 215197 | 21929 | 60 | 26.000 | A | 0.000 | A | G35 | 0.00 | 0.00 | 0 | 6.39 | G35 Gooseneck Arm | |
| 215226 | 21930 | 60 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 2.75 | 420-Orange | |
| 215307 | 21936 | 60 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 2.75 | 470-Watermelon | |
| 216917 | 22012 | 60 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 2.75 | 420-Orange | |
| 240946 | 21930 | 63 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 2.75 | 430-Soft Clay | |
| 240951 | 22012 | 63 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 2.75 | 430-Soft Clay | |
| 215121 | 21927 | 65 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 215198 | 21929 | 65 | 30.000 | A | 0.000 | A | G34 | 0.00 | 0.00 | 0 | 7.31 | G34 Gooseneck Arm | |
| 215227 | 21930 | 65 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 2.75 | 470-Watermelon | |
| 215308 | 21936 | 65 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 2.75 | 480-Blush Pink | |
| 216918 | 22012 | 65 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 2.75 | 470-Watermelon | |
| 215122 | 21927 | 70 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 215199 | 21929 | 70 | 16.000 | A | 0.000 | A | G5 | 0.00 | 0.00 | 0 | 3.93 | G5 Gooseneck Arm | |
| 215228 | 21930 | 70 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 2.75 | 480-Blush Pink | |
| 215309 | 21936 | 70 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 2.75 | 490-Magenta | |
| 216919 | 22012 | 70 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 2.75 | 480-Blush Pink | |
| 215123 | 21927 | 75 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 215200 | 21929 | 75 | 21.000 | A | 0.000 | A | G25 | 0.00 | 0.00 | 0 | 5.22 | G25 Gooseneck Arm | |
| 215229 | 21930 | 75 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 2.75 | 490-Magenta | |
| 215310 | 21936 | 75 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 2.75 | 495-Sherbet Orange | |
| 216920 | 22012 | 75 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 2.75 | 490-Magenta | |
| 215124 | 21927 | 80 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 215201 | 21929 | 80 | 28.000 | A | 0.000 | A | G10 | 0.00 | 0.00 | 0 | 6.90 | G10 Gooseneck Arm | |
| 215230 | 21930 | 80 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 2.75 | 495-Sherbet Orange | |
| 215311 | 21936 | 80 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 2.75 | 500-Buttery Yellow | |
| 216921 | 22012 | 80 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 2.75 | 495-Sherbet Orange | |
| 236846 | 21927 | 82 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 4.50 | 106-Matte Black | |
| 236847 | 21927 | 84 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 4.50 | 206-Matte White | |
| 215125 | 21927 | 85 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 4.50 | 307-Emerald Green | |
| 215202 | 21929 | 85 | 97.000 | A | 0.000 | A | G19 | 0.00 | 0.00 | 0 | 24.23 | G19 Gooseneck Arm | |
| 215231 | 21930 | 85 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 2.75 | 500-Buttery Yellow | |
| 215312 | 21936 | 85 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 2.75 | 570-Sunflower | |
| 216922 | 22012 | 85 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 2.75 | 500-Buttery Yellow | |
| 245086 | 21927 | 86 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 240940 | 21927 | 87 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 4.50 | 320-Fern Green | |
| 215126 | 21927 | 90 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 4.50 | 370-Mint | |
| 215203 | 21929 | 90 | 190.000 | A | 0.000 | A | G65 | 0.00 | 0.00 | 0 | 47.43 | G65 Gooseeneck Arm | |
| 215232 | 21930 | 90 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 2.75 | 570-Sunflower | |
| 215313 | 21936 | 90 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 2.75 | 600-Bronze | |
| 216923 | 22012 | 90 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 2.75 | 570-Sunflower | |
| 215127 | 21927 | 95 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 4.50 | 380-Chartreuse | |
| 215204 | 21929 | 95 | 158.000 | A | 0.000 | A | G64 | 0.00 | 0.00 | 0 | 39.43 | G64 Gooseneck Arm | |
| 215233 | 21930 | 95 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 2.75 | 600-Bronze | |
| 215314 | 21936 | 95 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 2.75 | 601-Chocolate | |
| 216924 | 22012 | 95 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 2.75 | 600-Bronze | |
| 240957 | 21936 | 98 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 2.75 | 607-Taupe | |
| 215128 | 21927 | 100 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 4.50 | 390-Teal | |
| 215205 | 21929 | 100 | 8.000 | A | 0.000 | A | G12 | 0.00 | 0.00 | 0 | 1.94 | G12 Gooseneck Arm | |
| 215234 | 21930 | 100 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 2.75 | 601-Chocolate | |
| 215315 | 21936 | 100 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 2.75 | 615-Oil-Rubbed Bronze | |
| 216925 | 22012 | 100 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 2.75 | 601-Chocolate | |
| 240947 | 21930 | 103 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 2.75 | 607-Taupe | |
| 240952 | 22012 | 103 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 2.75 | 607-Taupe | |
| 240958 | 21936 | 103 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 2.75 | 630-Beige | |
| 215129 | 21927 | 105 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 4.50 | 400-Barn Red | |
| 215206 | 21929 | 105 | 10.000 | A | 0.000 | A | G13 | 0.00 | 0.00 | 0 | 2.36 | G13 Gooseneck Arm | |
| 215235 | 21930 | 105 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 2.75 | 615-Oil-Rubbed Bronze | |
| 215316 | 21936 | 105 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 2.75 | 700-Royal Blue | |
| 216926 | 22012 | 105 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 2.75 | 615-Oil-Rubbed Bronze | |
| 240948 | 21930 | 108 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 2.75 | 630-Beige | |
| 240953 | 22012 | 108 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 2.75 | 630-Beige | |
| 215130 | 21927 | 110 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 4.50 | 420-Orange | |
| 215207 | 21929 | 110 | 23.000 | A | 0.000 | A | G32 | 0.00 | 0.00 | 0 | 5.53 | G32 Gooseneck Arm | |
| 215236 | 21930 | 110 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 2.75 | 700-Royal Blue | |
| 215317 | 21936 | 110 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 2.75 | 705-Navy | |
| 216927 | 22012 | 110 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 2.75 | 700-Royal Blue | |
| 245099 | 21936 | 112 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 240941 | 21927 | 113 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 4.50 | 430-Soft Clay | |
| 245100 | 21936 | 113 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 215131 | 21927 | 115 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 4.50 | 470-Watermelon | |
| 215237 | 21930 | 115 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 2.75 | 705-Navy | |
| 215318 | 21936 | 115 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 2.75 | 790-Lavender | |
| 216928 | 22012 | 115 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 2.75 | 705-Navy | |
| 245111 | 21930 | 116 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245115 | 22012 | 116 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245112 | 21930 | 117 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 245116 | 22012 | 117 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 225917 | 21930 | 118 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 2.75 | 790-Lavender | |
| 225918 | 22012 | 118 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 2.75 | 790-Lavender | |
| 231559 | 22012 | 119 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 2.75 | 800-Industrial Grey | |
| 231560 | 21930 | 119 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 2.75 | 800-Industrial Grey | |
| 215132 | 21927 | 120 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 4.50 | 480-Blush Pink | |
| 215209 | 21929 | 120 | 35.000 | A | 0.000 | A | G2 | 0.00 | 0.00 | 0 | 8.52 | G2 Gooseneck Arm | |
| 215238 | 21930 | 120 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 2.75 | 805-Charcoal Granite | |
| 215319 | 21936 | 120 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 2.75 | 800-Industrial Grey | |
| 216929 | 22012 | 120 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 2.75 | 805-Charcoal Granite | |
| 245113 | 21930 | 123 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 245117 | 22012 | 123 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 240954 | 22012 | 124 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 215133 | 21927 | 125 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 4.50 | 490-Magenta | |
| 215210 | 21929 | 125 | 39.000 | A | 0.000 | A | G36 | 0.00 | 0.00 | 0 | 9.53 | G36 Gooseneck Arm | |
| 215320 | 21936 | 125 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 2.75 | 805-Charcoal Granite | |
| 216930 | 22012 | 125 | 93.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 23.25 | 995-Raw Copper | |
| 240949 | 21930 | 125 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 2.75 | 815-Light Grey | |
| 245101 | 21936 | 126 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 240959 | 21936 | 128 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 2.75 | 815-Light Grey | |
| 215134 | 21927 | 130 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 4.50 | 495-Sherbet Orange | |
| 215211 | 21929 | 130 | 25.000 | A | 0.000 | A | G7 | 0.00 | 0.00 | 0 | 6.02 | G7 Gooseneck Arm | |
| 216931 | 22012 | 130 | 93.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 23.25 | 996-Weathered Copper | |
| 215135 | 21927 | 135 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 4.50 | 500-Buttery Yellow | |
| 215212 | 21929 | 135 | 32.000 | A | 0.000 | A | G9 | 0.00 | 0.00 | 0 | 7.90 | G9 Gooseneck Arm | |
| 215240 | 21930 | 135 | 125.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 31.25 | 995-Raw Copper | |
| 216932 | 22012 | 135 | 93.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 23.25 | 999-Oil-Rubbed Copper | |
| 215136 | 21927 | 140 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 4.50 | 570-Sunflower | |
| 215213 | 21929 | 140 | 141.000 | A | 0.000 | A | G40 | 0.00 | 0.00 | 0 | 35.23 | G40 Gooseneck Arm | |
| 215241 | 21930 | 140 | 125.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 31.25 | 996-Weathered Copper | |
| 216933 | 22012 | 140 | 93.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 23.25 | 997-Raw Brass | |
| 215137 | 21927 | 145 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 4.50 | 600-Bronze | |
| 215242 | 21930 | 145 | 125.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 31.25 | 999-Oil-Rubbed Copper | |
| 216934 | 22012 | 145 | 93.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 23.25 | 998-Weathered Brass | |
| 215138 | 21927 | 150 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 4.50 | 601-Chocolate | |
| 215243 | 21930 | 150 | 125.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 31.25 | 997-Raw Brass | |
| 240942 | 21927 | 153 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 4.50 | 607-Taupe | |
| 215139 | 21927 | 155 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 4.50 | 615-Oil-Rubbed Bronze | |
| 215244 | 21930 | 155 | 125.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 31.25 | 998-Weathered Brass | |
| 240943 | 21927 | 158 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 4.50 | 630-Beige | |
| 215140 | 21927 | 160 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 4.50 | 700-Royal Blue | |
| 215141 | 21927 | 165 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 4.50 | 705-Navy | |
| 245087 | 21927 | 166 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245088 | 21927 | 167 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 225909 | 21927 | 168 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 4.50 | 790-Lavender | |
| 215142 | 21927 | 170 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 4.50 | 800-Industrial Grey | |
| 215143 | 21927 | 175 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 4.50 | 805-Charcoal Granite | |
| 245089 | 21927 | 176 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 240944 | 21927 | 178 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 4.50 | 815-Light Grey | |
| 215144 | 21927 | 180 | 160.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 40.00 | 995-Raw Copper | |
| 215145 | 21927 | 185 | 200.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 50.00 | 996-Weathered Copper | |
| 215146 | 21927 | 190 | 250.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 70.00 | 999-Oil-Rubbed Copper | |
| 215147 | 21927 | 195 | 210.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 55.00 | 997-Raw Brass | |
| 215148 | 21927 | 200 | 250.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 75.00 | 998-Weathered Brass |