SELECT 
  a.variant_id, 
  a.option_id, 
  a.position, 
  a.modifier, 
  a.modifier_type, 
  a.weight_modifier, 
  a.weight_modifier_type, 
  a.nav_skus, 
  a.commercial_modifier, 
  a.commercial_dn, 
  a.same_as_option, 
  a.price_overrides, 
  a.base_cost, 
  b.variant_name, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier, 
    a.modifier
  ) as modifier, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier_type, 
    a.modifier_type
  ) as modifier_type 
FROM 
  cscart_product_option_variants as a 
  LEFT JOIN cscart_product_option_variants_descriptions as b ON a.variant_id = b.variant_id 
  AND b.lang_code = 'en' 
  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id 
  AND shared_option_variants.company_id = 1 
WHERE 
  a.option_id IN (
    23395, 23338, 23339, 23340, 23396, 23342, 
    23343, 23344, 23349, 23353, 23350, 
    23352, 23351, 23354, 23355, 23345, 
    23397, 23199
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00279

JSON explain

{
  "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": 284,
          "filtered": 100,
          "index_condition": "a.option_id in (23395,23338,23339,23340,23396,23342,23343,23344,23349,23353,23350,23352,23351,23354,23355,23345,23397,23199) 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')"
    }
  }
}

Result

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
232064 23199 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
233820 23338 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
233853 23339 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
233870 23340 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
233930 23342 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
233945 23343 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
233976 23344 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
233977 23345 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
234004 23349 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234009 23350 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234020 23351 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234031 23352 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234042 23353 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234079 23354 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234092 23355 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234680 23395 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
234707 23396 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234708 23397 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
234681 23396 1 11.000 A 0.000 A G26 0.00 0.00 0 0.00 G26 Gooseneck Arm
233822 23339 3 0.000 A 0.000 A 0.00 0.00 23338 0.00 Same as Shade
233856 23340 3 0.000 A 0.000 A 0.00 0.00 23338 0.00 Same as Shade
233899 23342 3 0.000 A 0.000 A 0.00 0.00 23338 0.00 Same as Shade
233931 23343 3 0.000 A 0.000 A 0.00 0.00 23338 0.00 Same as Shade
233946 23344 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
234053 23354 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
234677 23395 3 0.000 A 0.000 A AIL12 0.00 0.00 0 0.00 12" Shade
244982 23338 3 79.000 A 0.000 A M103 50.00 0.00 0 0.00 M103-Black
232065 23199 5 0.000 A 0.000 A 2700K 0.00 0.00 0 0.00 2700K - Warm White/Soft White
233823 23339 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
233900 23342 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
233947 23344 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
233978 23345 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
234005 23349 5 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
234010 23350 5 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
234021 23351 5 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
234032 23352 5 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
234043 23353 5 0.000 A 0.000 A CLR 0.00 0.00 0 0.00 Clear Glass
234054 23354 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
234678 23395 5 13.000 A 0.000 A AIL14 0.00 0.00 0 0.00 14" Shade
234682 23396 5 12.000 A 0.000 A G11 0.00 0.00 0 0.00 G11 Gooseneck Arm
234709 23397 5 0.000 A 0.000 A LED42 0.00 0.00 0 0.00 Up to 3000 Lumens
244983 23338 5 79.000 A 0.000 A M200 50.00 0.00 0 0.00 M200-White
244990 23340 5 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
245006 23355 5 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
245022 23343 5 0.000 A 0.000 A M103 0.00 0.00 0 0.00 M103-Black
232066 23199 10 0.000 A 0.000 A 3000K 0.00 0.00 0 0.00 3000K - Neutral White
233824 23339 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
233901 23342 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
233948 23344 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
233979 23345 10 24.000 A 0.000 A CBL 0.00 0.00 0 0.00 Support Cable (Recommended)
234006 23349 10 18.000 A 0.000 A WGG 0.00 0.00 0 0.00 Wire Guard
234011 23350 10 10.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
234022 23351 10 10.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
234033 23352 10 10.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
234044 23353 10 10.000 A 0.000 A FST 0.00 0.00 0 0.00 Frosted Glass
234055 23354 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
234679 23395 10 24.000 A 0.000 A AIL16 0.00 0.00 0 0.00 16" Shade
234683 23396 10 15.000 A 0.000 A G15 0.00 0.00 0 0.00 G15 Gooseneck Arm
234710 23397 10 36.000 A 0.000 A LED48 0.00 0.00 0 0.00 Up to 3500 Lumens
244984 23338 10 79.000 A 0.000 A M305 50.00 0.00 0 0.00 M305-Forest Green
244991 23340 10 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
245007 23355 10 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
245023 23343 10 0.000 A 0.000 A M200 0.00 0.00 0 0.00 M200-White
232067 23199 15 0.000 A 0.000 A 3500K 0.00 0.00 0 0.00 3500K - Bright White
233825 23339 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
233902 23342 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
233949 23344 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
234007 23349 15 18.000 A 0.000 A CGG 0.00 0.00 0 0.00 Standard Cast Guard
234012 23350 15 10.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
234023 23351 15 10.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
234034 23352 15 10.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
234045 23353 15 10.000 A 0.000 A RIB 0.00 0.00 0 0.00 Ribbed Glass
234056 23354 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
234684 23396 15 17.000 A 0.000 A G22 0.00 0.00 0 0.00 G22 Gooseneck Arm
234711 23397 15 70.000 A 0.000 A LED57 0.00 0.00 0 0.00 Up to 4000 Lumens
244985 23338 15 79.000 A 0.000 A M603 50.00 0.00 0 0.00 M603-Brown
244992 23340 15 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
245008 23355 15 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
245024 23343 15 0.000 A 0.000 A M305 0.00 0.00 0 0.00 M305-Forest Green
234702 23396 18 14.000 A 0.000 A G8 0.00 0.00 0 0.00 G8 Gooseneck Arm
232068 23199 20 0.000 A 0.000 A 4000K 0.00 0.00 0 0.00 4000K - Cool White
233826 23339 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
233903 23342 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
233950 23344 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
234008 23349 20 18.000 A 0.000 A TGG 0.00 0.00 0 0.00 Heavy Duty Guard
234057 23354 20 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
234685 23396 20 26.000 A 0.000 A G24 0.00 0.00 0 0.00 G24 Gooseneck Arm
234712 23397 20 105.000 A 0.000 A LED62 0.00 0.00 0 0.00 Up to 4500 Lumens
244986 23338 20 79.000 A 0.000 A M415 50.00 0.00 0 0.00 M415-Red
244993 23340 20 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
245009 23355 20 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
245025 23343 20 0.000 A 0.000 A M603 0.00 0.00 0 0.00 M603-Brown
232069 23199 25 0.000 A 0.000 A 5000K 0.00 0.00 0 0.00 5000K - Daylight
233827 23339 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
233904 23342 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
233951 23344 25 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
234058 23354 25 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
234686 23396 25 26.000 A 0.000 A G6 0.00 0.00 0 0.00 G6 Gooseneck Arm
234713 23397 25 139.000 A 0.000 A LED70 0.00 0.00 0 0.00 Up to 4700 Lumens
244987 23338 25 79.000 A 0.000 A M315 50.00 0.00 0 0.00 M315-Seafoam
244994 23340 25 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
245010 23355 25 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
245026 23343 25 0.000 A 0.000 A M415 0.00 0.00 0 0.00 M415-Red
236998 23354 27 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
233847 23339 28 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
236999 23354 28 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
233828 23339 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
233905 23342 30 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
233906 23342 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
233952 23344 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
234059 23354 30 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
234687 23396 30 0.000 A 0.000 A G3 0.00 0.00 0 0.00 G3 Straight Arm
244988 23338 30 79.000 A 0.000 A M803 50.00 0.00 0 0.00 M803-Dark Grey
244995 23340 30 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
245011 23355 30 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
245027 23343 30 0.000 A 0.000 A M315 0.00 0.00 0 0.00 M315-Seafoam
244989 23338 31 79.000 A 0.000 A M210 50.00 0.00 0 0.00 M210-Cream
236992 23339 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237002 23342 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237004 23344 32 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
236993 23339 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237003 23342 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
237005 23344 33 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
241766 23354 33 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
233829 23339 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
233907 23342 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
233953 23344 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
234060 23354 35 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
234688 23396 35 0.000 A 0.000 A G4 0.00 0.00 0 0.00 G4 Straight Arm
244996 23340 35 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
245012 23355 35 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
245028 23343 35 0.000 A 0.000 A M803 0.00 0.00 0 0.00 M803-Dark Grey
241756 23339 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241782 23342 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241787 23344 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
233830 23339 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
233908 23342 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
233954 23344 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
234061 23354 40 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
234689 23396 40 4.000 A 0.000 A G1 0.00 0.00 0 0.00 G1 Straight Arm
244997 23340 40 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
245013 23355 40 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
245029 23343 40 0.000 A 0.000 A M210 0.00 0.00 0 0.00 M210-Cream
233831 23339 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
233909 23342 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
233955 23344 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
234062 23354 45 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
234690 23396 45 4.000 A 0.000 A G14 0.00 0.00 0 0.00 G14 Straight Arm
233832 23339 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
233910 23342 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
233956 23344 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
234063 23354 50 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
234691 23396 50 2.000 A 0.000 A G16 0.00 0.00 0 0.00 G16 Straight Arm
233790 23338 55 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
233833 23339 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
233911 23342 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
233957 23344 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
234064 23354 55 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
234692 23396 55 2.000 A 0.000 A G17 0.00 0.00 0 0.00 G17 Straight Arm
241767 23354 58 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
233791 23338 60 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
233834 23339 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
233912 23342 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
233958 23344 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
234065 23354 60 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
234693 23396 60 26.000 A 0.000 A G35 0.00 0.00 0 0.00 G35 Gooseneck Arm
241757 23339 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241783 23342 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241788 23344 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
233792 23338 65 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
233835 23339 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
233913 23342 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
233959 23344 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
234066 23354 65 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
234694 23396 65 30.000 A 0.000 A G34 0.00 0.00 0 0.00 G34 Gooseneck Arm
233793 23338 70 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
233836 23339 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
233914 23342 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
233960 23344 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
234067 23354 70 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
233794 23338 75 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
233837 23339 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
233915 23342 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
233961 23344 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
234068 23354 75 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
234695 23396 75 21.000 A 0.000 A G25 0.00 0.00 0 0.00 G25 Gooseneck Arm
233795 23338 80 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
233838 23339 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
233916 23342 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
233962 23344 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
234069 23354 80 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
234696 23396 80 28.000 A 0.000 A G10 0.00 0.00 0 0.00 G10 Gooseneck Arm
236994 23338 82 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
236995 23338 83 18.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
233796 23338 85 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
233839 23339 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
233917 23342 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
233963 23344 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
234070 23354 85 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
241751 23338 88 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
233797 23338 90 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
233840 23339 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
233918 23342 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
233964 23344 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
234071 23354 90 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
234697 23396 90 190.000 A 0.000 A G65 0.00 0.00 0 0.00 G65 Gooseneck Arm
233798 23338 95 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
233841 23339 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
233919 23342 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
233965 23344 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
234072 23354 95 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
234698 23396 95 158.000 A 0.000 A G64 0.00 0.00 0 0.00 G64 Gooseneck Arm
241768 23354 98 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
233799 23338 100 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
233842 23339 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
233920 23342 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
233966 23344 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
234073 23354 100 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
234699 23396 100 8.000 A 0.000 A G12 0.00 0.00 0 0.00 G12 Gooseneck Arm
241758 23339 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241769 23354 103 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241784 23342 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241789 23344 103 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
233800 23338 105 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
233843 23339 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
233921 23342 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
233967 23344 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
234074 23354 105 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
234700 23396 105 10.000 A 0.000 A G13 0.00 0.00 0 0.00 G13 Gooseneck Arm
241759 23339 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241785 23342 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241790 23344 108 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
233801 23338 110 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
233844 23339 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
233922 23342 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
233968 23344 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
234075 23354 110 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
234701 23396 110 23.000 A 0.000 A G32 0.00 0.00 0 0.00 G32 Gooseneck Arm
241752 23338 113 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
233802 23338 115 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
233845 23339 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
233923 23342 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
233969 23344 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
234076 23354 115 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
233854 23339 118 11.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
233855 23339 119 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
233803 23338 120 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
233846 23339 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
233924 23342 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
233970 23344 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
234077 23354 120 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
234703 23396 120 35.000 A 0.000 A G2 0.00 0.00 0 0.00 G2 Gooseneck Arm
241760 23339 123 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241786 23342 123 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241791 23344 123 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
233804 23338 125 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
234078 23354 125 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
234704 23396 125 39.000 A 0.000 A G36 0.00 0.00 0 0.00 G36 Gooseneck Arm
241770 23354 128 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
233805 23338 130 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
234706 23396 130 25.000 A 0.000 A G7 0.00 0.00 0 0.00 G7 Gooseneck Arm
233806 23338 135 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
234705 23396 135 32.000 A 0.000 A G9 0.00 0.00 0 0.00 G9 Gooseneck Arm
233807 23338 140 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
233928 23342 140 125.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
233974 23344 140 125.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
233808 23338 145 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
233929 23342 145 125.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
233975 23344 145 125.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass
233809 23338 150 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241753 23338 153 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
233810 23338 155 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241754 23338 158 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
233811 23338 160 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
233812 23338 165 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
233821 23338 168 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
233813 23338 170 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
233814 23338 175 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
241755 23338 178 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
233815 23338 180 160.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
233816 23338 185 200.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
233817 23338 190 250.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
233818 23338 195 210.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
233819 23338 200 250.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass