Sandbox

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 (
    22637, 22638, 21970, 22639, 22035, 22039, 
    22029, 22030, 22031, 22034, 22040, 
    23537, 21941, 22748, 22747, 22707, 
    22708, 22709, 23003, 21961, 21967, 
    21962, 22934, 22144, 22015, 22018, 
    22019, 21984, 21985, 23187, 22952, 
    23185, 23556, 22254, 23188, 22675, 
    22644, 22645
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00508

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": 446,
          "filtered": 100,
          "index_condition": "a.option_id in (22637,22638,21970,22639,22035,22039,22029,22030,22031,22034,22040,23537,21941,22748,22747,22707,22708,22709,23003,21961,21967,21962,22934,22144,22015,22018,22019,21984,21985,23187,22952,23185,23556,22254,23188,22675,22644,22645) 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_type	nav_skus	same_as_option	base_cost	variant_name
218476	21970	0	0.000	A	A	unselected	0	0.00	Please Select
220181	22035	0	0.000	A	A	skip	0	0.00	Please Select
220230	22039	0	0.000	A	A	skip	0	0.00	Please Select
220232	22144	0	0.000	A	A	skip	0	0.00	Please Select
220238	22254	0	0.000	A	A	skip	0	0.00	Please Select
220240	22018	0	0.000	A	A	skip	0	0.00	Please Select
220241	22019	0	0.000	A	A	skip	0	0.00	Please Select
220245	22030	0	0.000	A	A	skip	0	0.00	Please Select
220246	22031	0	0.000	A	A	skip	0	0.00	Please Select
220252	22029	0	0.000	A	A	skip	0	0.00	Please Select
220264	22015	0	0.000	A	A	skip	0	0.00	Please Select
220271	22034	0	0.000	A	A	skip	0	0.00	Please Select
220272	22040	0	0.000	A	A	skip	0	0.00	Please Select
220300	21961	0	0.000	A	A	skip	0	0.00	Please Select
220303	21984	0	0.000	A	A	skip	0	0.00	Please Select
220307	21967	0	0.000	A	A	skip	0	0.00	Please Select
220308	21962	0	0.000	A	A	skip	0	0.00	Please Select
220309	21985	0	0.000	A	A	skip	0	0.00	Please Select
220318	21941	0	0.000	A	A	skip	0	0.00	Please Select
223697	22637	0	0.000	A	A	unselected	0	0.00	Please Select
223704	22638	0	0.000	A	A	skip	0	0.00	Please Select
223735	22639	0	0.000	A	A	skip	0	0.00	Please Select
223755	22644	0	0.000	A	A	skip	0	0.00	Please Select
223760	22645	0	0.000	A	A	skip	0	0.00	Please Select
224224	22675	0	0.000	A	A	skip	0	0.00	Please Select
224937	22707	0	0.000	A	A	skip	0	0.00	Please Select
224948	22708	0	0.000	A	A	skip	0	0.00	Please Select
224959	22709	0	0.000	A	A	skip	0	0.00	Please Select
225709	22747	0	0.000	A	A	skip	0	0.00	Please Select
225710	22748	0	0.000	A	A	unselected	0	0.00	Please Select
228384	22934	0	0.000	A	A	unselected	0	0.00	Please Select
228624	22952	0	0.000	A	A	unselected	0	0.00	Please Select
229740	23003	0	0.000	A	A	skip	0	0.00	Please Select
231909	23185	0	0.000	A	A	skip	0	0.00	Please Select
231944	23187	0	0.000	A	A	skip	0	0.00	Please Select
231948	23188	0	0.000	A	A	skip	0	0.00	Please Select
236827	23537	0	0.000	A	A	skip	0	0.00	Please Select
237599	23556	0	0.000	A	A	skip	0	0.00	Please Select
223698	22637	1	0.000	A	A		0	0.00	Standard Bulb E26/GU24
225711	22748	1	0.000	A	A		0	0.00	Standard Bulb E26/GU24
223705	22638	2	0.000	A	A	CLAR8	0	0.00	8" Shade
215376	21941	3	0.000	A	A	E26	0	0.00	E26
215616	21961	3	0.000	A	A	NA	0	0.00	None
215618	21962	3	0.000	A	A	NA	0	0.00	None
215660	21967	3	0.000	A	A	SBK	0	0.00	Standard Black
215713	21970	3	0.000	A	A	100	0	0.00	100-Black
215974	21984	3	0.000	A	A	NA	0	0.00	None
215976	21985	3	0.000	A	A	NA	0	0.00	None
216983	22015	3	0.000	A	A	CLR	0	0.00	Clear Glass
216999	22018	3	0.000	A	A	CLR	0	0.00	Clear Glass
217009	22019	3	0.000	A	A	CLR	0	0.00	Clear Glass
217142	22029	3	0.000	A	A	CLR	0	0.00	Clear Glass
217152	22030	3	0.000	A	A	CLR	0	0.00	Clear Glass
217162	22031	3	0.000	A	A	CLR	0	0.00	Clear Glass
217205	22034	3	0.000	A	A	100	0	0.00	100-Black
217235	22035	3	0.000	A	A		21970	0.00	Same as Shade
217303	22039	3	0.000	A	A	NA	0	0.00	None
217308	22040	3	0.000	A	A	100	0	0.00	100-Black
223706	22639	3	11.000	A	A	G26	0	0.00	G26 Gooseneck Arm
224927	22707	3	0.000	A	A	CLR	0	0.00	Clear Glass
224938	22708	3	0.000	A	A	CLR	0	0.00	Clear Glass
224949	22709	3	0.000	A	A	CLR	0	0.00	Clear Glass
228594	22952	3	0.000	A	A	100	0	0.00	100-Black
229710	23003	3	0.000	A	A	100	0	0.00	100-Black
231880	23185	3	11.000	A	A	G26	0	0.00	G26 Gooseneck Arm
231946	23188	3	0.000	A	A	NA	0	0.00	None
236823	23537	3	0.000	A	A	NA	0	0.00	None
237569	23556	3	0.000	A	A		22952	0.00	Same as Shade
215377	21941	5	14.000	A	A	GU24	0	3.50	GU24
215617	21961	5	50.000	A	A	L-WL	0	0.00	Plug with Inline Switch
215619	21962	5	58.000	A	A	DD	0	0.00	Dusk-to-Dawn Photocell
215661	21967	5	5.000	A	A	SWH	0	0.00	Standard White
215714	21970	5	0.000	A	A	105	0	0.00	105-Textured Black
215975	21984	5	62.000	A	A	L-WL	0	0.00	Plug with Inline On/Off Switch
215977	21985	5	58.000	A	A	DD	0	0.00	Dusk-to-Dawn Photocell
216984	22015	5	10.000	A	A	FST	0	0.00	Frosted Glass
217000	22018	5	10.000	A	A	FST	0	0.00	Frosted Glass
217010	22019	5	10.000	A	A	FST	0	0.00	Frosted Glass
217143	22029	5	10.000	A	A	FST	0	0.00	Frosted Glass
217153	22030	5	10.000	A	A	FST	0	0.00	Frosted Glass
217163	22031	5	10.000	A	A	FST	0	0.00	Frosted Glass
217206	22034	5	0.000	A	A	105	0	0.00	105-Textured Black
217236	22035	5	0.000	A	A	100	0	0.00	100-Black
217309	22040	5	0.000	A	A	105	0	0.00	105-Textured Black
218151	22144	5	0.000	A	A	NA	0	0.00	None
219398	22254	5	0.000	A	A	NA	0	0.00	None
223699	22637	5	0.000	A	A		0	0.00	Integrated LED
223701	22638	5	24.000	A	A	CLAR12	0	0.00	12" Shade
223707	22639	5	12.000	A	A	G11	0	0.00	G11 Gooseneck Arm
223756	22644	5	0.000	A	A	2700K	0	0.00	2700K - Warm White/Soft White
223761	22645	5	0.000	A	A	DL	0	0.00	Domed Lens
224225	22675	5	0.000	A	A	LED11	0	0.00	850 Lumens
224928	22707	5	10.000	A	A	FST	0	0.00	Frosted Glass
224939	22708	5	10.000	A	A	FST	0	0.00	Frosted Glass
224950	22709	5	10.000	A	A	FST	0	0.00	Frosted Glass
225707	22747	5	0.000	A	A	LAR12	0	0.00	12" Shade
225712	22748	5	0.000	A	A		0	0.00	Integrated LED
228385	22934	5	0.000	A	A		0	0.00	Standard Bulb E26/GU24
228595	22952	5	0.000	A	A	105	0	0.00	105-Textured Black
229711	23003	5	0.000	A	A	105	0	0.00	105-Textured Black
231881	23185	5	12.000	A	A	G11	0	0.00	G11 Gooseneck Arm
231941	23187	5	0.000	A	A	LAR12	0	0.00	12" Shade
231947	23188	5	43.000	A	A	LDBPC	0	0.00	Decorative BP Cover
236824	23537	5	43.000	A	A	DBPC	0	0.00	Decorative BP Cover
237570	23556	5	0.000	A	A	100	0	0.00	100-Black
217264	22035	8	0.000	A	A	105	0	0.00	105-Textured Black
233544	23188	8	65.000	A	A	LDCHX	0	0.00	Decorative BP & Hex Cover
236828	23537	8	61.000	A	A	DCHX	0	0.00	Decorative BP & Hex Cover
237598	23556	8	0.000	A	A	105	0	0.00	105-Textured Black
215662	21967	10	10.000	A	A	CSB	0	0.00	Black Cloth
215715	21970	10	0.000	A	A	200	0	0.00	200-White
216985	22015	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
217001	22018	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
217011	22019	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
217144	22029	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
217154	22030	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
217164	22031	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
217207	22034	10	0.000	A	A	200	0	0.00	200-White
217237	22035	10	0.000	A	A	200	0	0.00	200-White
217304	22039	10	49.000	A	A	WC	0	6.25	Wire Cage
217310	22040	10	0.000	A	A	200	0	0.00	200-White
219399	22254	10	49.000	A	A	WC	0	6.25	Wire Cage
223708	22639	10	15.000	A	A	G15	0	0.00	G15 Gooseneck Arm
223757	22644	10	0.000	A	A	3000K	0	0.00	3000K - Neutral White
223762	22645	10	0.000	A	A	FL	0	0.00	Flat Lens
224226	22675	10	0.000	A	A	LED16	0	0.00	1250 Lumens
224929	22707	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
224940	22708	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
224951	22709	10	10.000	A	A	RIB	0	0.00	Ribbed Glass
228386	22934	10	0.000	A	A		0	0.00	Integrated LED
228596	22952	10	0.000	A	A	200	0	0.00	200-White
229712	23003	10	0.000	A	A	200	0	0.00	200-White
231882	23185	10	15.000	A	A	G15	0	0.00	G15 Gooseneck Arm
236825	23537	10	92.000	A	A	DD	0	0.00	Dusk-to-Dawn Photocell
237571	23556	10	0.000	A	A	200	0	0.00	200-White
215663	21967	15	10.000	A	A	SLVR	0	0.00	Silver Cloth
215716	21970	15	0.000	A	A	300	0	0.00	300-Dark Green
217208	22034	15	0.000	A	A	300	0	0.00	300-Dark Green
217238	22035	15	0.000	A	A	300	0	0.00	300-Dark Green
217305	22039	15	97.000	A	A	WGG	0	16.34	Wire Guard & Glass
217311	22040	15	0.000	A	A	300	0	0.00	300-Dark Green
218152	22144	15	97.000	A	A	WGG	0	0.00	Wire Guard & Glass
223703	22638	15	47.000	A	A	CLAR16	0	0.00	16" Shade
223709	22639	15	17.000	A	A	G22	0	0.00	G22 Gooseneck Arm
223758	22644	15	0.000	A	A	3500K	0	0.00	3500K - Bright White
228597	22952	15	0.000	A	A	300	0	0.00	300-Dark Green
229713	23003	15	0.000	A	A	300	0	0.00	300-Dark Green
231883	23185	15	17.000	A	A	G22	0	0.00	G22 Gooseneck Arm
231943	23187	15	36.000	A	A	LAR16	0	0.00	16" Shade
236826	23537	15	83.000	A	A	HDBP	0	0.00	Heavy Duty BP
237572	23556	15	0.000	A	A	300	0	0.00	300-Dark Green
238251	22747	15	47.000	A	A	LAR16	0	0.00	16" Shade
215738	21970	18	0.000	A	A	975	0	0.00	975-Galvanized
223729	22639	18	14.000	A	A	G8	0	0.00	G8 Gooseneck Arm
228619	22952	18	0.000	A	A	975	0	0.00	975-Galvanized
231903	23185	18	14.000	A	A	G8	0	0.00	G8 Gooseneck Arm
215731	21970	19	0.000	A	A	605	0	0.00	605-Textured Rust
228612	22952	19	0.000	A	A	605	0	0.00	605-Textured Rust
215664	21967	20	10.000	A	A	CRM	0	0.00	Creme Cloth
217209	22034	20	0.000	A	A	975	0	0.00	975-Galvanized
217239	22035	20	0.000	A	A	975	0	0.00	975-Galvanized
217306	22039	20	97.000	A	A	CGG	0	16.22	Cast Guard & Glass
217312	22040	20	0.000	A	A	975	0	0.00	975-Galvanized
218153	22144	20	97.000	A	A	CGG	0	0.00	Cast Guard & Glass
223710	22639	20	26.000	A	A	G24	0	0.00	G24 Gooseneck Arm
223759	22644	20	0.000	A	A	4000K	0	0.00	4000K - Cool White
229714	23003	20	0.000	A	A	975	0	0.00	975-Galvanized
231884	23185	20	26.000	A	A	G24	0	0.00	G24 Gooseneck Arm
237573	23556	20	0.000	A	A	975	0	0.00	975-Galvanized
237036	21970	21	18.000	A	A	106	0	0.00	106-Matte Black
237074	22952	21	18.000	A	A	106	0	0.00	106-Matte Black
237037	21970	22	18.000	A	A	206	0	0.00	206-Matte White
237075	22952	22	18.000	A	A	206	0	0.00	206-Matte White
215717	21970	24	18.000	A	A	307	0	0.00	307-Emerald Green
228598	22952	24	18.000	A	A	307	0	0.00	307-Emerald Green
215665	21967	25	10.000	A	A	BPNK	0	0.00	Blush Pink Cloth
217210	22034	25	0.000	A	A	605	0	0.00	605-Textured Rust
217240	22035	25	0.000	A	A	980	0	0.00	980-Brushed Aluminum
217307	22039	25	97.000	A	A	TGG	0	17.63	Heavy Duty Guard & Glass
217313	22040	25	0.000	A	A	605	0	0.00	605-Textured Rust
218154	22144	25	97.000	A	A	TGG	0	0.00	Heavy Guard & Glass
223711	22639	25	26.000	A	A	G6	0	0.00	G6 Gooseneck Arm
229715	23003	25	0.000	A	A	605	0	0.00	605-Rust
231885	23185	25	26.000	A	A	G6	0	0.00	G6 Gooseneck Arm
237574	23556	25	0.000	A	A	980	0	0.00	980-Brushed Aluminum
242135	21970	25	18.000	A	A	311	0	0.00	311-Jadite
242509	22952	25	18.000	A	A	311	0	0.00	311-Jadite
241141	21970	26	18.000	A	A	320	0	0.00	320-Fern Green
241555	22952	26	18.000	A	A	320	0	0.00	320-Fern Green
237040	22034	27	11.000	A	A	106	0	0.00	106-Matte Black
237062	22040	27	11.000	A	A	106	0	0.00	106-Matte Black
237088	23003	27	11.000	A	A	106	0	0.00	106-Matte Black
215718	21970	28	18.000	A	A	370	0	0.00	370-Mint
228599	22952	28	18.000	A	A	370	0	0.00	370-Mint
237041	22034	28	11.000	A	A	206	0	0.00	206-Matte White
237063	22040	28	11.000	A	A	206	0	0.00	206-Matte White
237089	23003	28	11.000	A	A	206	0	0.00	206-Matte White
215666	21967	30	20.000	A	A	CNF	0	0.00	Confetti Cloth
215719	21970	30	18.000	A	A	380	0	0.00	380-Chartreuse
217211	22034	30	11.000	A	A	307	0	0.00	307-Emerald Green
217241	22035	30	0.000	A	A	605	0	0.00	605-Textured Rust
217314	22040	30	11.000	A	A	307	0	0.00	307-Emerald Green
223712	22639	30	0.000	A	A	G3	0	0.00	G3 Straight Arm
228600	22952	30	18.000	A	A	380	0	0.00	380-Chartreuse
229716	23003	30	11.000	A	A	307	0	0.00	307-Emerald Green
231886	23185	30	0.000	A	A	G3	0	0.00	G3 Straight Arm
237575	23556	30	0.000	A	A	605	0	0.00	605-Textured Rust
237038	22035	32	11.000	A	A	106	0	0.00	106-Matte Black
237601	23556	32	11.000	A	A	106	0	0.00	106-Matte Black
242263	22040	32	11.000	A	A	311	0	0.00	311-Jadite
242752	22034	32	11.000	A	A	311	0	0.00	311-Jadite
237039	22035	33	11.000	A	A	206	0	0.00	206-Matte White
237602	23556	33	11.000	A	A	206	0	0.00	206-Matte White
241171	22040	33	11.000	A	A	320	0	0.00	320-Fern Green
241221	22034	33	11.000	A	A	320	0	0.00	320-Fern Green
215667	21967	35	10.000	A	A	RST	0	0.00	Rust Cloth
215720	21970	35	18.000	A	A	390	0	0.00	390-Teal
217212	22034	35	11.000	A	A	370	0	0.00	370-Mint
217242	22035	35	11.000	A	A	307	0	0.00	307-Emerald Green
217315	22040	35	11.000	A	A	370	0	0.00	370-Mint
223713	22639	35	0.000	A	A	G4	0	0.00	G4 Straight Arm
228601	22952	35	18.000	A	A	390	0	0.00	390-Teal
229717	23003	35	11.000	A	A	370	0	0.00	370-Mint
231887	23185	35	0.000	A	A	G4	0	0.00	G4 Straight Arm
237576	23556	35	11.000	A	A	307	0	0.00	307-Emerald Green
242657	22035	36	11.000	A	A	311	0	0.00	311-Jadite
241261	22035	38	11.000	A	A	320	0	0.00	320-Fern Green
242105	23556	38	11.000	A	A	320	0	0.00	320-Fern Green
215668	21967	40	15.000	A	A	RBS	0	0.00	Barn Red & Black Swirl Cloth
215721	21970	40	18.000	A	A	400	0	0.00	400-Barn Red
217213	22034	40	11.000	A	A	380	0	0.00	380-Chartreuse
217243	22035	40	11.000	A	A	370	0	0.00	370-Mint
217316	22040	40	11.000	A	A	380	0	0.00	380-Chartreuse
223714	22639	40	4.000	A	A	G1	0	0.00	G1 Straight Arm
228602	22952	40	18.000	A	A	400	0	0.00	400-Barn Red
229718	23003	40	11.000	A	A	380	0	0.00	380-Chartreuse
231888	23185	40	4.000	A	A	G1	0	0.00	G1 Straight Arm
237577	23556	40	11.000	A	A	370	0	0.00	370-Mint
215669	21967	45	10.000	A	A	ORG	0	0.00	Orange Cloth
215722	21970	45	18.000	A	A	420	0	0.00	420-Orange
217214	22034	45	11.000	A	A	390	0	0.00	390-Teal
217244	22035	45	11.000	A	A	380	0	0.00	380-Chartreuse
217317	22040	45	11.000	A	A	390	0	0.00	390-Teal
223715	22639	45	4.000	A	A	G14	0	0.00	G14 Straight Arm
228603	22952	45	18.000	A	A	420	0	0.00	420-Orange
229719	23003	45	11.000	A	A	390	0	0.00	390-Teal
231889	23185	45	4.000	A	A	G14	0	0.00	G14 Straight Arm
237578	23556	45	11.000	A	A	380	0	0.00	380-Chartreuse
241142	21970	48	18.000	A	A	430	0	0.00	430-Soft Clay
241556	22952	48	18.000	A	A	430	0	0.00	430-Soft Clay
215670	21967	50	10.000	A	A	YLW	0	0.00	Buttery Yellow Cloth
215723	21970	50	18.000	A	A	470	0	0.00	470-Watermelon
217215	22034	50	11.000	A	A	400	0	0.00	400-Barn Red
217245	22035	50	11.000	A	A	390	0	0.00	390-Teal
217318	22040	50	11.000	A	A	400	0	0.00	400-Barn Red
223716	22639	50	2.000	A	A	G16	0	0.00	G16 Straight Arm
228604	22952	50	18.000	A	A	470	0	0.00	470-Watermelon
229720	23003	50	11.000	A	A	400	0	0.00	400-Barn Red
231890	23185	50	2.000	A	A	G16	0	0.00	G16 Straight Arm
237579	23556	50	11.000	A	A	390	0	0.00	390-Teal
215671	21967	55	10.000	A	A	NGRN	0	0.00	Neon Green Cloth
215724	21970	55	18.000	A	A	480	0	0.00	480-Blush Pink
217216	22034	55	11.000	A	A	420	0	0.00	420-Orange
217246	22035	55	11.000	A	A	400	0	0.00	400-Barn Red
217319	22040	55	11.000	A	A	420	0	0.00	420-Orange
223717	22639	55	2.000	A	A	G17	0	0.00	G17 Straight Arm
228605	22952	55	18.000	A	A	480	0	0.00	480-Blush Pink
229721	23003	55	11.000	A	A	420	0	0.00	420-Orange
231891	23185	55	2.000	A	A	G17	0	0.00	G17 Straight Arm
237580	23556	55	11.000	A	A	400	0	0.00	400-Barn Red
241172	22040	58	11.000	A	A	430	0	0.00	430-Soft Clay
241222	22034	58	11.000	A	A	430	0	0.00	430-Soft Clay
215672	21967	60	10.000	A	A	EGRN	0	0.00	Emerald Green Cloth
215725	21970	60	18.000	A	A	490	0	0.00	490-Magenta
217217	22034	60	11.000	A	A	470	0	0.00	470-Watermelon
217247	22035	60	11.000	A	A	420	0	0.00	420-Orange
217320	22040	60	11.000	A	A	470	0	0.00	470-Watermelon
223718	22639	60	26.000	A	A	G35	0	0.00	G35 Gooseneck Arm
228606	22952	60	18.000	A	A	490	0	0.00	490-Magenta
229722	23003	60	11.000	A	A	470	0	0.00	470-Watermelon
231892	23185	60	26.000	A	A	G35	0	0.00	G35 Gooseneck Arm
237581	23556	60	11.000	A	A	420	0	0.00	420-Orange
241262	22035	63	11.000	A	A	430	0	0.00	430-Soft Clay
242106	23556	63	11.000	A	A	430	0	0.00	430-Soft Clay
215673	21967	65	20.000	A	A	FGRN	0	0.00	Fern Green Chevron Cloth
215726	21970	65	18.000	A	A	495	0	0.00	495-Sherbet Orange
217218	22034	65	11.000	A	A	480	0	0.00	480-Blush Pink
217248	22035	65	11.000	A	A	470	0	0.00	470-Watermelon
217321	22040	65	11.000	A	A	480	0	0.00	480-Blush Pink
223719	22639	65	30.000	A	A	G34	0	0.00	G34 Gooseneck Arm
228607	22952	65	18.000	A	A	495	0	0.00	495-Sherbet Orange
229723	23003	65	11.000	A	A	480	0	0.00	480-Blush Pink
231893	23185	65	30.000	A	A	G34	0	0.00	G34 Gooseneck Arm
237582	23556	65	11.000	A	A	470	0	0.00	470-Watermelon
215727	21970	70	18.000	A	A	500	0	0.00	500-Buttery Yellow
217219	22034	70	11.000	A	A	490	0	0.00	490-Magenta
217249	22035	70	11.000	A	A	480	0	0.00	480-Blush Pink
217322	22040	70	11.000	A	A	490	0	0.00	490-Magenta
223720	22639	70	16.000	A	A	G5	0	0.00	G5 Gooseneck Arm
228608	22952	70	18.000	A	A	500	0	0.00	500-Buttery Yellow
229724	23003	70	11.000	A	A	490	0	0.00	490-Magenta
231894	23185	70	16.000	A	A	G5	0	0.00	G5 Gooseneck Arm
237583	23556	70	11.000	A	A	480	0	0.00	480-Blush Pink
243095	21967	70	10.000	A	A	SFM	0	0.00	Seafoam Cloth
215728	21970	75	18.000	A	A	570	0	0.00	570-Sunflower
217220	22034	75	11.000	A	A	495	0	0.00	495-Sherbet Orange
217250	22035	75	11.000	A	A	490	0	0.00	490-Magenta
217323	22040	75	11.000	A	A	495	0	0.00	495-Sherbet Orange
223721	22639	75	21.000	A	A	G25	0	0.00	G25 Gooseneck Arm
228609	22952	75	18.000	A	A	570	0	0.00	570-Sunflower
229725	23003	75	11.000	A	A	495	0	0.00	495-Sherbet Orange
231895	23185	75	21.000	A	A	G25	0	0.00	G25 Gooseneck Arm
237584	23556	75	11.000	A	A	490	0	0.00	490-Magenta
243096	21967	75	10.000	A	A	SBLU	0	0.00	Sky Blue Cloth
215729	21970	80	18.000	A	A	600	0	0.00	600-Bronze
217221	22034	80	11.000	A	A	500	0	0.00	500-Buttery Yellow
217251	22035	80	11.000	A	A	495	0	0.00	495-Sherbet Orange
217324	22040	80	11.000	A	A	500	0	0.00	500-Buttery Yellow
223722	22639	80	28.000	A	A	G10	0	0.00	G10 Gooseneck Arm
228610	22952	80	18.000	A	A	600	0	0.00	600-Bronze
229726	23003	80	11.000	A	A	500	0	0.00	500-Buttery Yellow
231896	23185	80	28.000	A	A	G10	0	0.00	G10 Gooseneck Arm
237585	23556	80	11.000	A	A	495	0	0.00	495-Sherbet Orange
243097	21967	80	10.000	A	A	RBLU	0	0.00	Royal Blue Cloth
215730	21970	85	18.000	A	A	601	0	0.00	601-Chocolate
217222	22034	85	11.000	A	A	570	0	0.00	570-Sunflower
217252	22035	85	11.000	A	A	500	0	0.00	500-Buttery Yellow
217325	22040	85	11.000	A	A	570	0	0.00	570-Sunflower
223723	22639	85	97.000	A	A	G19	0	0.00	G19 Gooseneck Arm
228611	22952	85	18.000	A	A	601	0	0.00	601-Chocolate
229727	23003	85	11.000	A	A	570	0	0.00	570-Sunflower
237586	23556	85	11.000	A	A	500	0	0.00	500-Buttery Yellow
243098	21967	85	10.000	A	A	NVY	0	0.00	Navy Cloth
241557	22952	88	18.000	A	A	607	0	0.00	607-Taupe
217223	22034	90	11.000	A	A	600	0	0.00	600-Bronze
217253	22035	90	11.000	A	A	570	0	0.00	570-Sunflower
217326	22040	90	11.000	A	A	600	0	0.00	600-Bronze
223724	22639	90	190.000	A	A	G65	0	0.00	G65 Gooseneck Arm
229728	23003	90	11.000	A	A	600	0	0.00	600-Bronze
231898	23185	90	190.000	A	A	G65	0	0.00	G65 Gooseneck Arm
237587	23556	90	11.000	A	A	570	0	0.00	570-Sunflower
241143	21970	90	18.000	A	A	607	0	0.00	607-Taupe
215732	21970	95	18.000	A	A	615	0	0.00	615-Oil-Rubbed Bronze
217224	22034	95	11.000	A	A	601	0	0.00	601-Chocolate
217254	22035	95	11.000	A	A	600	0	0.00	600-Bronze
217327	22040	95	11.000	A	A	601	0	0.00	601-Chocolate
223725	22639	95	158.000	A	A	G64	0	0.00	G64 Gooseneck Arm
228613	22952	95	18.000	A	A	615	0	0.00	615-Oil-Rubbed Bronze
229729	23003	95	11.000	A	A	601	0	0.00	601-Chocolate
231899	23185	95	158.000	A	A	G64	0	0.00	G64 Gooseneck Arm
237588	23556	95	11.000	A	A	600	0	0.00	600-Bronze
241144	21970	98	18.000	A	A	630	0	0.00	630-Beige
241173	22040	98	11.000	A	A	607	0	0.00	607-Taupe
241223	22034	98	11.000	A	A	607	0	0.00	607-Taupe
241558	22952	98	18.000	A	A	630	0	0.00	630-Beige
215733	21970	100	18.000	A	A	700	0	0.00	700-Royal Blue
217225	22034	100	11.000	A	A	615	0	0.00	615-Oil-Rubbed Bronze
217255	22035	100	11.000	A	A	601	0	0.00	601-Chocolate
217328	22040	100	11.000	A	A	615	0	0.00	615-Oil-Rubbed Bronze
223726	22639	100	8.000	A	A	G12	0	0.00	G12 Gooseneck Arm
228614	22952	100	18.000	A	A	700	0	0.00	700-Royal Blue
229730	23003	100	11.000	A	A	615	0	0.00	615-Oil-Rubbed Bronze
231900	23185	100	8.000	A	A	G12	0	0.00	G12 Gooseneck Arm
237589	23556	100	11.000	A	A	601	0	0.00	601-Chocolate
241224	22034	103	11.000	A	A	630	0	0.00	630-Beige
241263	22035	103	11.000	A	A	607	0	0.00	607-Taupe
242107	23556	103	11.000	A	A	607	0	0.00	607-Taupe
215734	21970	105	18.000	A	A	705	0	0.00	705-Navy
217226	22034	105	11.000	A	A	700	0	0.00	700-Royal Blue
217256	22035	105	11.000	A	A	615	0	0.00	615-Oil-Rubbed Bronze
223727	22639	105	10.000	A	A	G13	0	0.00	G13 Gooseneck Arm
228615	22952	105	18.000	A	A	705	0	0.00	705-Navy
229731	23003	105	11.000	A	A	700	0	0.00	700-Royal Blue
231901	23185	105	10.000	A	A	G13	0	0.00	G13 Gooseneck Arm
237590	23556	105	11.000	A	A	615	0	0.00	615-Oil-Rubbed Bronze
241174	22040	105	11.000	A	A	630	0	0.00	630-Beige
242108	23556	106	11.000	A	A	630	0	0.00	630-Beige
242510	22952	107	18.000	A	A	710	0	0.00	710-Cobalt Blue
241264	22035	108	11.000	A	A	630	0	0.00	630-Beige
242511	22952	109	18.000	A	A	715	0	0.00	715-Delphite Blue
215735	21970	110	18.000	A	A	790	0	0.00	790-Lavender
217227	22034	110	11.000	A	A	705	0	0.00	705-Navy
217257	22035	110	11.000	A	A	700	0	0.00	700-Royal Blue
217329	22040	110	11.000	A	A	700	0	0.00	700-Royal Blue
223728	22639	110	23.000	A	A	G32	0	0.00	G32 Gooseneck Arm
228616	22952	110	18.000	A	A	790	0	0.00	790-Lavender
229732	23003	110	11.000	A	A	705	0	0.00	705-Navy
231902	23185	110	23.000	A	A	G32	0	0.00	G32 Gooseneck Arm
237591	23556	110	11.000	A	A	700	0	0.00	700-Royal Blue
242136	21970	112	18.000	A	A	710	0	0.00	710-Cobalt Blue
242753	22034	112	11.000	A	A	710	0	0.00	710-Cobalt Blue
242137	21970	113	18.000	A	A	715	0	0.00	715-Delphite Blue
242754	22034	114	11.000	A	A	715	0	0.00	715-Delphite Blue
215736	21970	115	18.000	A	A	800	0	0.00	800-Industrial Grey
217228	22034	115	11.000	A	A	790	0	0.00	790-Lavender
217258	22035	115	11.000	A	A	705	0	0.00	705-Navy
217330	22040	115	11.000	A	A	705	0	0.00	705-Navy
228617	22952	115	18.000	A	A	800	0	0.00	800-Industrial Grey
229733	23003	115	11.000	A	A	790	0	0.00	790-Lavender
237592	23556	115	11.000	A	A	705	0	0.00	705-Navy
242658	22035	116	11.000	A	A	710	0	0.00	710-Cobalt Blue
242659	22035	117	11.000	A	A	715	0	0.00	715-Delphite Blue
237600	23556	118	11.000	A	A	800	0	0.00	800-Industrial Grey
242264	22040	118	11.000	A	A	710	0	0.00	710-Cobalt Blue
243002	22035	118	11.000	A	A	790	0	0.00	790-Lavender
230712	22035	119	11.000	A	A	800	0	0.00	800-Industrial Grey
242265	22040	119	11.000	A	A	715	0	0.00	715-Delphite Blue
215737	21970	120	18.000	A	A	805	0	0.00	805-Charcoal Granite
217229	22034	120	11.000	A	A	800	0	0.00	800-Industrial Grey
217259	22035	120	11.000	A	A	805	0	0.00	805-Charcoal Granite
217331	22040	120	11.000	A	A	790	0	0.00	790-Lavender
223730	22639	120	35.000	A	A	G2	0	0.00	G2 Gooseneck Arm
228618	22952	120	18.000	A	A	805	0	0.00	805-Charcoal Granite
229734	23003	120	11.000	A	A	800	0	0.00	800-Industrial Grey
231904	23185	120	35.000	A	A	G2	0	0.00	G2 Gooseneck Arm
237593	23556	120	11.000	A	A	805	0	0.00	805-Charcoal Granite
242512	22952	122	18.000	A	A	810	0	0.00	810-Graphite
242660	22035	122	11.000	A	A	810	0	0.00	810-Graphite
241265	22035	123	11.000	A	A	815	0	0.00	815-Light Grey
241559	22952	123	18.000	A	A	815	0	0.00	815-Light Grey
242109	23556	123	11.000	A	A	815	0	0.00	815-Light Grey
242138	21970	123	18.000	A	A	810	0	0.00	810-Graphite
217230	22034	125	11.000	A	A	805	0	0.00	805-Charcoal Granite
217332	22040	125	11.000	A	A	800	0	0.00	800-Industrial Grey
223731	22639	125	39.000	A	A	G36	0	0.00	G36 Gooseneck Arm
229735	23003	125	11.000	A	A	805	0	0.00	805-Charcoal Granite
231905	23185	125	39.000	A	A	G36	0	0.00	G36 Gooseneck Arm
241145	21970	125	18.000	A	A	815	0	0.00	815-Light Grey
242732	23556	125	11.000	A	A	311	0	0.00	311-Jadite
242733	23556	127	11.000	A	A	710	0	0.00	710-Cobalt Blue
242755	22034	127	11.000	A	A	810	0	0.00	810-Graphite
241225	22034	128	11.000	A	A	815	0	0.00	815-Light Grey
242734	23556	129	11.000	A	A	715	0	0.00	715-Delphite Blue
217333	22040	130	11.000	A	A	805	0	0.00	805-Charcoal Granite
223732	22639	130	25.000	A	A	G7	0	0.00	G7 Gooseneck Arm
229736	23003	130	11.000	A	A	311	0	0.00	311-Jadite
231906	23185	130	25.000	A	A	G7	0	0.00	G7 Gooseneck Arm
242735	23556	131	11.000	A	A	810	0	0.00	810-Graphite
242266	22040	132	11.000	A	A	810	0	0.00	810-Graphite
241175	22040	133	11.000	A	A	815	0	0.00	815-Light Grey
223733	22639	135	32.000	A	A	G9	0	0.00	G9 Gooseneck Arm
229737	23003	135	17.000	A	A	710	0	0.00	710-Cobalt Blue
231907	23185	135	32.000	A	A	G9	0	0.00	G9 Gooseneck Arm
223734	22639	140	141.000	A	A	G40	0	0.00	G40 Gooseneck Arm
229738	23003	140	17.000	A	A	715	0	0.00	715-Delphite Blue
229739	23003	145	17.000	A	A	810	0	0.00	810-Graphite