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 (
    23869, 23523, 23897, 23524, 23188, 23132, 
    22644, 23901, 21970, 23902, 23551, 
    22643, 22645, 21954, 23900, 23553, 
    23981, 23982, 23978, 23983, 23871, 
    23979
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00355

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": 336,
          "filtered": 100,
          "index_condition": "a.option_id in (23869,23523,23897,23524,23188,23132,22644,23901,21970,23902,23551,22643,22645,21954,23900,23553,23981,23982,23978,23983,23871,23979) 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
218476 21970 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
220173 21954 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
223749 22643 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
223760 22645 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
230951 23132 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
231948 23188 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
236498 23523 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
236530 23524 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
237449 23551 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
237517 23553 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
240709 23869 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
240716 23871 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
243078 23897 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
243113 23900 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
243120 23901 0 0.000 A 0.000 A DBO23 0.00 0.00 0 0.00 23" Shade
243121 23902 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
243829 23978 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
243830 23979 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
243838 23981 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
243841 23982 0 0.000 A 0.000 A unselected 0.00 0.00 0 0.00 Please Select
243876 23983 0 0.000 A 0.000 A skip 0.00 0.00 0 0.00 Please Select
215556 21954 3 0.000 A 0.000 A SBK 0.00 0.00 0 0.00 Standard Black
215713 21970 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
231946 23188 3 0.000 A 0.000 A NA 0.00 0.00 0 0.00 None
236468 23523 3 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
236499 23524 3 0.000 A 0.000 A 0.00 0.00 23523 0.00 Same as Shade
237418 23551 3 0.000 A 0.000 A 0.00 0.00 21970 0.00 Same as Shade
237486 23553 3 0.000 A 0.000 A 0.00 0.00 21970 0.00 Same as Shade
243049 23897 3 11.000 A 0.000 A G26 0.00 0.00 0 0.00 G26 Gooseneck Arm
243825 23978 3 0.000 A 0.000 A ASH 0.00 0.00 0 0.00 Ash Wood
215557 21954 5 5.000 A 0.000 A SWH 0.00 0.00 0 0.32 Standard White
215714 21970 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
223750 22643 5 0.000 A 0.000 A LED11 0.00 0.00 0 0.00 850 Lumens
223756 22644 5 0.000 A 0.000 A 2700K 0.00 0.00 0 0.00 2700K - Warm White/Soft White
223761 22645 5 0.000 A 0.000 A DL 0.00 0.00 0 0.00 Domed Lens
230952 23132 5 0.000 A 0.000 A LED11 0.00 0.00 0 0.00 850 Lumens
231947 23188 5 43.000 A 0.000 A LDBPC 0.00 0.00 0 0.00 Decorative BP Cover
236469 23523 5 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
236500 23524 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
237419 23551 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
237487 23553 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
240715 23871 5 0.000 A 0.000 A LED10 0.00 0.00 0 0.00 1035 Lumen
243050 23897 5 12.000 A 0.000 A G11 0.00 0.00 0 0.00 G11 Gooseneck Arm
243826 23978 5 0.000 A 0.000 A MPL 0.00 0.00 0 0.00 Maple Wood
243831 23979 5 0.000 A 0.000 A 2700K 0.00 0.00 0 0.00 2700K - Warm White/Soft White
243840 23981 5 0.000 A 0.000 A DCM 0.00 0.00 0 0.00 Dual Canopy Mount
243842 23982 5 0.000 A 0.000 A LIN2 0.00 0.00 0 0.00 23.5" Light
243846 23983 5 0.000 A 0.000 A 100 0.00 0.00 0 0.00 100-Black
233544 23188 8 65.000 A 0.000 A LDCHX 0.00 0.00 0 0.00 Decorative BP & Hex Cover
215558 21954 10 10.000 A 0.000 A CSB 0.00 0.00 0 3.66 Black Cloth
215715 21970 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
223751 22643 10 0.000 A 0.000 A LED16 0.00 0.00 0 0.00 1250 Lumens
223757 22644 10 0.000 A 0.000 A 3000K 0.00 0.00 0 0.00 3000K - Neutral White
223762 22645 10 0.000 A 0.000 A FL 0.00 0.00 0 0.00 Flat Lens
230953 23132 10 0.000 A 0.000 A LED16 0.00 0.00 0 0.00 1250 Lumens
236470 23523 10 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
236501 23524 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
237420 23551 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
237488 23553 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
240707 23869 10 0.000 A 0.000 A LEGT12 0.00 0.00 0 0.00 12" Disk & 6" Globe
243051 23897 10 15.000 A 0.000 A G15 0.00 0.00 0 0.00 G15 Gooseneck Arm
243123 23902 10 0.000 A 0.000 A ST712 0.00 0.00 0 0.00 12" Stem - ¾ Diameter
243827 23978 10 0.000 A 0.000 A OAK 0.00 0.00 0 0.00 Oak Wood
243832 23979 10 0.000 A 0.000 A 3000K 0.00 0.00 0 0.00 3000K - Neutral White
243839 23981 10 60.000 A 0.000 A SCM 0.00 0.00 0 0.00 Single Center Mount
243843 23982 10 26.000 A 0.000 A LIN3 0.00 0.00 0 0.00 34.5" Light
243847 23983 10 0.000 A 0.000 A 105 0.00 0.00 0 0.00 105-Textured Black
215559 21954 15 10.000 A 0.000 A SLVR 0.00 0.00 0 3.66 Silver Cloth
215716 21970 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
223752 22643 15 5.000 A 0.000 A LED27 0.00 0.00 0 1.25 2000 Lumens
223758 22644 15 0.000 A 0.000 A 3500K 0.00 0.00 0 0.00 3500K - Bright White
230954 23132 15 5.000 A 0.000 A LED27 0.00 0.00 0 1.25 2000 Lumens
236471 23523 15 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
236502 23524 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
237421 23551 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
237489 23553 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
243052 23897 15 17.000 A 0.000 A G22 0.00 0.00 0 0.00 G22 Gooseneck Arm
243124 23902 15 4.000 A 0.000 A ST718 0.00 0.00 0 0.00 18" Stem - ¾ Diameter
243828 23978 15 0.000 A 0.000 A WAL 0.00 0.00 0 0.00 Walnut Wood
243833 23979 15 0.000 A 0.000 A 3500K 0.00 0.00 0 0.00 3500K - Bright White
243844 23982 15 52.000 A 0.000 A LIN4 0.00 0.00 0 0.00 45.5" Light
243848 23983 15 0.000 A 0.000 A 200 0.00 0.00 0 0.00 200-White
215738 21970 18 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
236493 23523 18 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
243072 23897 18 14.000 A 0.000 A G8 0.00 0.00 0 0.00 G8 Gooseneck Arm
215731 21970 19 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
236486 23523 19 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
215560 21954 20 10.000 A 0.000 A CRM 0.00 0.00 0 3.66 Creme Cloth
223753 22643 20 15.000 A 0.000 A LED38 0.00 0.00 0 3.75 3000 Lumens
223759 22644 20 0.000 A 0.000 A 4000K 0.00 0.00 0 0.00 4000K - Cool White
236503 23524 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
237422 23551 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
237490 23553 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
240708 23869 20 64.000 A 0.000 A LEGT16 0.00 0.00 0 0.00 16" Disk & 8" Globe
243053 23897 20 26.000 A 0.000 A G24 0.00 0.00 0 0.00 G24 Gooseneck Arm
243117 23900 20 18.000 A 0.000 A 36 0.00 0.00 0 0.00 36" Cable & Cord
243125 23902 20 7.000 A 0.000 A ST724 0.00 0.00 0 0.00 24" Stem - ¾ Diameter
243849 23983 20 0.000 A 0.000 A 300 0.00 0.00 0 0.00 300-Dark Green
237036 21970 21 18.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
239867 23523 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
239868 23523 23 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
236472 23523 24 18.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
215561 21954 25 10.000 A 0.000 A BPNK 0.00 0.00 0 3.66 Blush Pink Cloth
223754 22643 25 23.000 A 0.000 A LED43 0.00 0.00 0 5.75 4000 Lumens
236504 23524 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
237423 23551 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
237491 23553 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
242135 21970 25 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
243054 23897 25 26.000 A 0.000 A G6 0.00 0.00 0 0.00 G6 Gooseneck Arm
243118 23900 25 24.000 A 0.000 A 72 0.00 0.00 0 0.00 72" Cable & Cord
243126 23902 25 10.000 A 0.000 A ST736 0.00 0.00 0 0.00 36" Stem - ¾ Diameter
243850 23983 25 0.000 A 0.000 A 975 0.00 0.00 0 0.00 975-Galvanized
241141 21970 26 18.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241640 23523 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
236473 23523 28 18.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
243870 23983 28 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
215562 21954 30 30.000 A 0.000 A CNF 0.00 0.00 0 10.66 Confetti Cloth
215719 21970 30 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
236474 23523 30 18.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
236505 23524 30 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
237424 23551 30 0.000 A 0.000 A 980 0.00 0.00 0 0.00 980-Brushed Aluminum
237492 23553 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
243055 23897 30 0.000 A 0.000 A G3 0.00 0.00 0 0.00 G3 Straight Arm
243119 23900 30 42.000 A 0.000 A 108 0.00 0.00 0 0.00 108" Cable & Cord
243127 23902 30 16.000 A 0.000 A ST748 0.00 0.00 0 0.00 48" Stem - ¾ Diameter
243851 23983 30 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
237518 23553 32 6.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237519 23553 33 6.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
244283 23983 33 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
244284 23983 34 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
215563 21954 35 10.000 A 0.000 A RST 0.00 0.00 0 3.66 Rust Cloth
215720 21970 35 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
236475 23523 35 18.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
236506 23524 35 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
237425 23551 35 0.000 A 0.000 A 605 0.00 0.00 0 0.00 605-Textured Rust
237493 23553 35 6.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
243056 23897 35 0.000 A 0.000 A G4 0.00 0.00 0 0.00 G4 Straight Arm
243852 23983 35 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
242143 23553 36 6.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
243877 23983 36 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
237450 23551 37 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
239869 23524 37 11.000 A 0.000 A 106 0.00 0.00 0 0.00 106-Matte Black
237451 23551 38 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
239870 23524 38 11.000 A 0.000 A 206 0.00 0.00 0 0.00 206-Matte White
241216 23553 38 6.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
243881 23983 38 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215564 21954 40 15.000 A 0.000 A RBS 0.00 0.00 0 6.81 Barn Red & Black Swirl Cloth
215721 21970 40 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
236476 23523 40 18.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
236507 23524 40 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
237426 23551 40 11.000 A 0.000 A 307 0.00 0.00 0 0.00 307-Emerald Green
237494 23553 40 6.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
243057 23897 40 4.000 A 0.000 A G1 0.00 0.00 0 0.00 G1 Straight Arm
243853 23983 40 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
242139 23551 42 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
241226 23551 43 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
241645 23524 43 11.000 A 0.000 A 320 0.00 0.00 0 0.00 320-Fern Green
215565 21954 45 10.000 A 0.000 A ORG 0.00 0.00 0 3.66 Orange Cloth
215722 21970 45 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
236477 23523 45 18.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
236508 23524 45 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
237427 23551 45 11.000 A 0.000 A 370 0.00 0.00 0 0.00 370-Mint
237495 23553 45 6.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
243058 23897 45 4.000 A 0.000 A G14 0.00 0.00 0 0.00 G14 Straight Arm
243854 23983 45 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
241142 21970 48 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241641 23523 48 18.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
215566 21954 50 10.000 A 0.000 A YLW 0.00 0.00 0 3.66 Buttery Yellow Cloth
215723 21970 50 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
236478 23523 50 18.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
236509 23524 50 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
237428 23551 50 11.000 A 0.000 A 380 0.00 0.00 0 0.00 380-Chartreuse
237496 23553 50 6.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
243059 23897 50 2.000 A 0.000 A G16 0.00 0.00 0 0.00 G16 Straight Arm
243855 23983 50 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
215567 21954 55 10.000 A 0.000 A NGRN 0.00 0.00 0 3.66 Neon Green Cloth
215724 21970 55 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
236479 23523 55 18.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
236510 23524 55 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
237429 23551 55 11.000 A 0.000 A 390 0.00 0.00 0 0.00 390-Teal
237497 23553 55 6.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
243060 23897 55 2.000 A 0.000 A G17 0.00 0.00 0 0.00 G17 Straight Arm
243856 23983 55 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
215568 21954 60 10.000 A 0.000 A EGRN 0.00 0.00 0 3.66 Emerald Green Cloth
215725 21970 60 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
236480 23523 60 18.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
236511 23524 60 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
237430 23551 60 11.000 A 0.000 A 400 0.00 0.00 0 0.00 400-Barn Red
237498 23553 60 6.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
243061 23897 60 26.000 A 0.000 A G35 0.00 0.00 0 0.00 G35 Gooseneck Arm
243857 23983 60 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
241217 23553 63 6.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
243882 23983 63 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
215569 21954 65 30.000 A 0.000 A FGRN 0.00 0.00 0 10.66 Fern Green Chevron Cloth
215726 21970 65 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
236481 23523 65 18.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
236512 23524 65 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
237431 23551 65 11.000 A 0.000 A 420 0.00 0.00 0 0.00 420-Orange
237499 23553 65 6.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
243062 23897 65 30.000 A 0.000 A G34 0.00 0.00 0 0.00 G34 Gooseneck Arm
243858 23983 65 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
241227 23551 68 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
241646 23524 68 11.000 A 0.000 A 430 0.00 0.00 0 0.00 430-Soft Clay
215727 21970 70 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
236482 23523 70 18.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
236513 23524 70 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
237432 23551 70 11.000 A 0.000 A 470 0.00 0.00 0 0.00 470-Watermelon
237500 23553 70 6.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
243063 23897 70 16.000 A 0.000 A G5 0.00 0.00 0 0.00 G5 Gooseneck Arm
243103 21954 70 10.000 A 0.000 A SFM 0.00 0.00 0 3.66 Seafoam Cloth
243859 23983 70 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
215728 21970 75 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
236483 23523 75 18.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
236514 23524 75 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
237433 23551 75 11.000 A 0.000 A 480 0.00 0.00 0 0.00 480-Blush Pink
237501 23553 75 6.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
243064 23897 75 21.000 A 0.000 A G25 0.00 0.00 0 0.00 G25 Gooseneck Arm
243104 21954 75 10.000 A 0.000 A SBLU 0.00 0.00 0 3.66 Sky Blue Cloth
243860 23983 75 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
215729 21970 80 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
236484 23523 80 18.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
236515 23524 80 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
237434 23551 80 11.000 A 0.000 A 490 0.00 0.00 0 0.00 490-Magenta
237502 23553 80 6.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
243065 23897 80 28.000 A 0.000 A G10 0.00 0.00 0 0.00 G10 Gooseneck Arm
243105 21954 80 10.000 A 0.000 A RBLU 0.00 0.00 0 3.66 Royal Blue Cloth
243861 23983 80 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
215730 21970 85 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
236485 23523 85 18.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
236516 23524 85 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
237435 23551 85 11.000 A 0.000 A 495 0.00 0.00 0 0.00 495-Sherbet Orange
237503 23553 85 6.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
243106 21954 85 10.000 A 0.000 A NVY 0.00 0.00 0 3.66 Navy Cloth
243862 23983 85 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
236517 23524 90 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
237436 23551 90 11.000 A 0.000 A 500 0.00 0.00 0 0.00 500-Buttery Yellow
237504 23553 90 6.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
241143 21970 90 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241642 23523 90 18.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
243067 23897 90 190.000 A 0.000 A G65 0.00 0.00 0 0.00 G65 Gooseneck Arm
243863 23983 90 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
215732 21970 95 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
236487 23523 95 18.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
236518 23524 95 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
237437 23551 95 11.000 A 0.000 A 570 0.00 0.00 0 0.00 570-Sunflower
237505 23553 95 6.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
243068 23897 95 158.000 A 0.000 A G64 0.00 0.00 0 0.00 G64 Gooseneck Arm
243864 23983 95 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
241144 21970 98 18.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241643 23523 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
236488 23523 100 18.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
236519 23524 100 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
237438 23551 100 11.000 A 0.000 A 600 0.00 0.00 0 0.00 600-Bronze
237506 23553 100 6.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
243069 23897 100 8.000 A 0.000 A G12 0.00 0.00 0 0.00 G12 Gooseneck Arm
243865 23983 100 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
241218 23553 103 6.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
243883 23983 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
236489 23523 105 18.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
236520 23524 105 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
237439 23551 105 11.000 A 0.000 A 601 0.00 0.00 0 0.00 601-Chocolate
237507 23553 105 6.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
243070 23897 105 10.000 A 0.000 A G13 0.00 0.00 0 0.00 G13 Gooseneck Arm
243866 23983 105 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
241219 23553 108 6.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241228 23551 108 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
241647 23524 108 11.000 A 0.000 A 607 0.00 0.00 0 0.00 607-Taupe
243884 23983 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
236490 23523 110 18.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
236521 23524 110 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
237440 23551 110 11.000 A 0.000 A 615 0.00 0.00 0 0.00 615-Oil-Rubbed Bronze
237508 23553 110 6.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
243071 23897 110 23.000 A 0.000 A G32 0.00 0.00 0 0.00 G32 Gooseneck Arm
243867 23983 110 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
242136 21970 112 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
241229 23551 113 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
241648 23524 113 11.000 A 0.000 A 630 0.00 0.00 0 0.00 630-Beige
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
236491 23523 115 18.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
236522 23524 115 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
237441 23551 115 11.000 A 0.000 A 700 0.00 0.00 0 0.00 700-Royal Blue
237509 23553 115 6.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
243868 23983 115 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
242144 23553 116 6.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242145 23553 117 6.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
243878 23983 117 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
243879 23983 118 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
215737 21970 120 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
236492 23523 120 18.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
236523 23524 120 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
237442 23551 120 11.000 A 0.000 A 705 0.00 0.00 0 0.00 705-Navy
237510 23553 120 6.000 A 0.000 A 790 0.00 0.00 0 0.00 790-Lavender
243073 23897 120 35.000 A 0.000 A G2 0.00 0.00 0 0.00 G2 Gooseneck Arm
243869 23983 120 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
243880 23983 121 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
243885 23983 122 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241644 23523 123 18.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
242140 23551 123 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242141 23551 124 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
236524 23524 125 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
237443 23551 125 11.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
237511 23553 125 6.000 A 0.000 A 800 0.00 0.00 0 0.00 800-Industrial Grey
241145 21970 125 18.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242852 23523 125 18.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
243074 23897 125 39.000 A 0.000 A G36 0.00 0.00 0 0.00 G36 Gooseneck Arm
242853 23523 127 18.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242854 23523 129 18.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
237512 23553 130 6.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
243075 23897 130 25.000 A 0.000 A G7 0.00 0.00 0 0.00 G7 Gooseneck Arm
242855 23523 131 18.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
242146 23553 132 6.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241220 23553 133 6.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
236525 23524 135 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
237444 23551 135 11.000 A 0.000 A 805 0.00 0.00 0 0.00 805-Charcoal Granite
243076 23897 135 32.000 A 0.000 A G9 0.00 0.00 0 0.00 G9 Gooseneck Arm
243871 23983 135 93.000 A 0.000 A 995 0.00 0.00 0 0.00 995-Raw Copper
242142 23551 136 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
241230 23551 138 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
241649 23524 138 11.000 A 0.000 A 815 0.00 0.00 0 0.00 815-Light Grey
242856 23524 140 11.000 A 0.000 A 311 0.00 0.00 0 0.00 311-Jadite
243872 23983 140 93.000 A 0.000 A 996 0.00 0.00 0 0.00 996-Weathered Copper
242857 23524 142 11.000 A 0.000 A 710 0.00 0.00 0 0.00 710-Cobalt Blue
242858 23524 144 11.000 A 0.000 A 715 0.00 0.00 0 0.00 715-Delphite Blue
243873 23983 145 93.000 A 0.000 A 999 0.00 0.00 0 0.00 999-Oil-Rubbed Copper
242859 23524 146 11.000 A 0.000 A 810 0.00 0.00 0 0.00 810-Graphite
243874 23983 150 93.000 A 0.000 A 997 0.00 0.00 0 0.00 997-Raw Brass
243875 23983 155 93.000 A 0.000 A 998 0.00 0.00 0 0.00 998-Weathered Brass