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 (
    22857, 22899, 22859, 21947, 22880, 22881, 
    22863, 22864, 22865, 22882, 22883, 
    22884, 22872, 22852, 21941, 22986, 
    22952, 21973, 22224, 22067, 22040, 
    23587, 22892, 22593, 22117, 22602, 
    22601, 22604, 22605, 22603, 22592, 
    23116, 22644
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00482

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": 538,
          "filtered": 100,
          "index_condition": "a.option_id in (22857,22899,22859,21947,22880,22881,22863,22864,22865,22882,22883,22884,22872,22852,21941,22986,22952,21973,22224,22067,22040,23587,22892,22593,22117,22602,22601,22604,22605,22603,22592,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')"
    }
  }
}

Result

variant_id	option_id	position	modifier	modifier_type	weight_modifier_type	nav_skus	same_as_option	price_overrides	base_cost	variant_name
220137	22117	0	0.000	A	A	unselected	0		0.00	Please Select
220172	21947	0	0.000	A	A	skip	0		0.00	Please Select
220194	21973	0	0.000	A	A	skip	0		0.00	Please Select
220212	22224	0	0.000	A	A	unselected	0		0.00	Please Select
220231	22067	0	0.000	A	A	skip	0		0.00	Please Select
220272	22040	0	0.000	A	A	skip	0		0.00	Please Select
220318	21941	0	0.000	A	A	skip	0		0.00	Please Select
222969	22592	0	0.000	A	A	skip	0		0.00	Please Select
222970	22593	0	0.000	A	A	skip	0		0.00	Please Select
223099	22601	0	0.000	A	A	skip	0		0.00	Please Select
223134	22602	0	0.000	A	A	skip	0		0.00	Please Select
223142	22603	0	0.000	A	A	skip	0		0.00	Please Select
223146	22604	0	0.000	A	A	skip	0		0.00	Please Select
223150	22605	0	0.000	A	A	skip	0		0.00	Please Select
223755	22644	0	0.000	A	A	skip	0		0.00	Please Select
227161	22852	0	0.000	A	A	skip	0		0.00	Please Select
227191	22857	0	0.000	A	A	unselected	0		0.00	Please Select
227233	22859	0	0.000	A	A	skip	0		0.00	Please Select
227335	22863	0	0.000	A	A	unselected	0		0.00	Please Select
227336	22863	0	0.000	A	A	NA	0		0.00	No Cap
227338	22864	0	0.000	A	A	unselected	0		0.00	Please Select
227339	22864	0	0.000	A	A	NA	0		0.00	No Cap
227341	22865	0	0.000	A	A	unselected	0		0.00	Please Select
227342	22865	0	0.000	A	A	NA	0		0.00	No Cap
227392	22872	0	0.000	A	A	skip	0		0.00	Please Select
227550	22880	0	0.000	A	A	skip	0		0.00	Please Select
227585	22881	0	0.000	A	A	skip	0		0.00	Please Select
227593	22882	0	0.000	A	A	skip	0		0.00	Please Select
227597	22883	0	0.000	A	A	skip	0		0.00	Please Select
227601	22884	0	0.000	A	A	skip	0		0.00	Please Select
227751	22892	0	0.000	A	A	skip	0		0.00	Please Select
227863	22899	0	0.000	A	A	skip	0		0.00	Please Select
228624	22952	0	0.000	A	A	unselected	0		0.00	Please Select
229352	22986	0	0.000	A	A	unselected	0		0.00	Please Select
230828	23116	0	0.000	A	A	unselected	0		0.00	Please Select
238137	23587	0	0.000	A	A	skip	0		0.00	Please Select
215376	21941	3	0.000	A	A	E26	0		0.00	E26
215783	21973	3	0.000	A	A		22952		0.00	Same as Shade
217308	22040	3	0.000	A	A	100	0		0.00	100-Black
217630	22067	3	0.000	A	A	NA	0		0.00	None
222959	22592	3	0.000	A	A	CLR	0		0.00	Clear Glass
223068	22601	3	0.000	A	A		22117		0.00	Same as Shade
223147	22605	3	0.000	A	A		0		0.00	Standard Canopy
227152	22852	3	0.000	A	A	CLR	0		0.00	Clear Glass
227519	22880	3	0.000	A	A		22859		0.00	Same as Shade
227598	22884	3	0.000	A	A		0		0.00	Standard Canopy
228594	22952	3	0.000	A	A	100	0		0.00	100-Black
229346	22986	3	0.000	A	A	ULW12	0		0.00	12" Shade
238107	23587	3	0.000	A	A	100	0		0.00	100-Black
238867	21947	3	0.000	A	A	ST506	0		0.00	6" Stem - ½" Diameter
215377	21941	5	14.000	A	A	GU24	0		3.50	GU24
215452	21947	5	1.000	A	A	ST706	0		0.18	6" Stem - ¾" Diameter
215784	21973	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
217631	22067	5	87.000	A	A	ACR	0	{"229346":"75.00","229347":"85.00","229348":"95.00","229349":"140.00","236650":"165.00"}	0.00	Acrylic Diffuser
219067	22224	5	0.000	A	A	SC	0		0.00	Standard Canopy
222960	22592	5	10.000	A	A	FST	0		0.00	Frosted Glass
222971	22593	5	0.000	A	A	ULC12	0		0.00	12" Shade
223069	22601	5	0.000	A	A	100	0		0.00	100-Black
223104	22602	5	0.000	A	A	100	0		0.00	100-Black
223139	22603	5	0.000	A	A		0		0.00	Standard Canopy
223143	22604	5	0.000	A	A		0		0.00	Standard Canopy
223756	22644	5	0.000	A	A	2700K	0		0.00	2700K - Warm White/Soft White
227153	22852	5	10.000	A	A	FST	0		0.00	Frosted Glass
227193	22857	5	0.000	A	A		0		0.00	Standard Bulb E26/GU24
227337	22863	5	18.000	A	A	CAP	0		0.00	With Cap
227340	22864	5	18.000	A	A	CAP	0		0.00	With Cap
227343	22865	5	18.000	A	A	CAP	0		0.00	With Cap
227520	22880	5	0.000	A	A	100	0		0.00	100-Black
227555	22881	5	0.000	A	A	100	0		0.00	100-Black
227590	22882	5	0.000	A	A		0		0.00	Standard Canopy
227594	22883	5	0.000	A	A		0		0.00	Standard Canopy
227752	22892	5	0.000	A	A	ULO12	0		0.00	12" Shade
227864	22899	5	0.000	A	A	ULA12	0		0.00	12" Shade
228595	22952	5	0.000	A	A	105	0		0.00	105-Textured Black
229347	22986	5	13.000	A	A	ULW14	0		0.00	14" Shade
230827	23116	5	0.000	A	A	LED16.8	0		0.00	16.8W LED - 1600 Lumen
238108	23587	5	0.000	A	A	105	0		0.00	105-Textured Black
215785	21973	10	0.000	A	A	105	0		0.00	105-Textured Black
217310	22040	10	0.000	A	A	200	0		0.00	200-White
217632	22067	10	49.000	A	A	WC	0		0.00	Wire Cage
219068	22224	10	44.000	A	A	HSC	0		0.00	25° Hang Straight Canopy
222961	22592	10	10.000	A	A	RIB	0		0.00	Ribbed Glass
222972	22593	10	13.000	A	A	ULC14	0		0.00	14" Shade
223070	22601	10	0.000	A	A	105	0		0.00	105-Textured Black
223105	22602	10	0.000	A	A	105	0		0.00	105-Textured Black
223140	22603	10	44.000	A	A	HSC	0		0.00	25° Hang Straight Canopy
223144	22604	10	44.000	A	A	HSC	0		0.00	25° Hang Straight Canopy
223148	22605	10	44.000	A	A	HSC	0		0.00	25° Hang Straight Canopy
223757	22644	10	0.000	A	A	3000K	0		0.00	3000K - Neutral White
227154	22852	10	10.000	A	A	RIB	0		0.00	Ribbed Glass
227192	22857	10	0.000	A	A		0		0.00	Nautical LED
227521	22880	10	0.000	A	A	105	0		0.00	105-Textured Black
227556	22881	10	0.000	A	A	105	0		0.00	105-Textured Black
227591	22882	10	44.000	A	A	HSC	0		0.00	25° Hang Straight Canopy
227595	22883	10	44.000	A	A	HSC	0		0.00	25° Hang Straight Canopy
227599	22884	10	44.000	A	A	HSC	0		0.00	25° Hang Straight Canopy
227753	22892	10	18.000	A	A	ULO14	0		0.00	14" Shade
227865	22899	10	18.000	A	A	ULA14	0		0.00	14" Shade
228596	22952	10	0.000	A	A	200	0		0.00	200-White
229348	22986	10	24.000	A	A	ULW16	0		0.00	16" Shade
238109	23587	10	0.000	A	A	200	0		0.00	200-White
238868	21947	10	3.000	A	A	ST512	0		0.56	12" Stem - ½" Diameter
215454	21947	15	4.000	A	A	ST712	0		0.92	12" Stem - ¾" Diameter
215786	21973	15	0.000	A	A	200	0		0.00	200-White
217311	22040	15	0.000	A	A	300	0		0.00	300-Dark Green
219069	22224	15	24.000	A	A	HDSMC	0		0.00	Heavy Duty Canopy
222973	22593	15	24.000	A	A	ULC16	0		0.00	16" Shade
223071	22601	15	0.000	A	A	200	0		0.00	200-White
223106	22602	15	0.000	A	A	200	0		0.00	200-White
223141	22603	15	24.000	A	A	HDSMC	0		0.00	Heavy Duty Canopy
223145	22604	15	24.000	A	A	HDSMC	0		0.00	Heavy Duty Canopy
223149	22605	15	24.000	A	A	HDSMC	0		0.00	Heavy Duty Canopy
223758	22644	15	0.000	A	A	3500K	0		0.00	3500K - Bright White
227522	22880	15	0.000	A	A	200	0		0.00	200-White
227557	22881	15	0.000	A	A	200	0		0.00	200-White
227592	22882	15	24.000	A	A	HDSMC	0		0.00	Heavy Duty Canopy
227596	22883	15	24.000	A	A	HDSMC	0		0.00	Heavy Duty Canopy
227600	22884	15	24.000	A	A	HDSMC	0		0.00	Heavy Duty Canopy
227754	22892	15	30.000	A	A	ULO16	0		0.00	16" Shade
227866	22899	15	30.000	A	A	ULA16	0		0.00	16" Shade
228597	22952	15	0.000	A	A	300	0		0.00	300-Dark Green
229349	22986	15	36.000	A	A	ULW18	0		0.00	18" Shade
238110	23587	15	0.000	A	A	300	0		0.00	300-Dark Green
228619	22952	18	0.000	A	A	975	0		0.00	975-Galvanized
228612	22952	19	0.000	A	A	605	0		0.00	605-Textured Rust
215787	21973	20	0.000	A	A	300	0		0.00	300-Dark Green
217312	22040	20	0.000	A	A	975	0		0.00	975-Galvanized
222974	22593	20	47.000	A	A	ULC18	0		0.00	18" Shade
223072	22601	20	0.000	A	A	300	0		0.00	300-Dark Green
223107	22602	20	0.000	A	A	300	0		0.00	300-Dark Green
223759	22644	20	0.000	A	A	4000K	0		0.00	4000K - Cool White
227523	22880	20	0.000	A	A	300	0		0.00	300-Dark Green
227558	22881	20	0.000	A	A	300	0		0.00	300-Dark Green
227755	22892	20	53.000	A	A	ULO18	0		0.00	18" Shade
236650	22986	20	47.000	A	A	ULW20	0		0.00	20" Shade
238111	23587	20	0.000	A	A	975	0		0.00	975-Galvanized
238869	21947	20	5.000	A	A	ST518	0		1.12	18" Stem - ½" Diameter
237074	22952	21	18.000	A	A	106	0		0.00	106-Matte Black
237075	22952	22	18.000	A	A	206	0		0.00	206-Matte White
228598	22952	24	18.000	A	A	307	0		0.00	307-Emerald Green
215456	21947	25	7.000	A	A	ST718	0		1.67	18" Stem - ¾" Diameter
215788	21973	25	0.000	A	A	975	0		0.00	975-Galvanized
217313	22040	25	0.000	A	A	605	0		0.00	605-Textured Rust
223073	22601	25	0.000	A	A	975	0		0.00	975-Galvanized
223108	22602	25	0.000	A	A	975	0		0.00	975-Galvanized
227524	22880	25	0.000	A	A	975	0		0.00	975-Galvanized
227559	22881	25	0.000	A	A	975	0		0.00	975-Galvanized
227756	22892	25	64.000	A	A	ULO20	0		0.00	20" Shade
238112	23587	25	0.000	A	A	605	0		0.00	605-Textured Rust
242509	22952	25	18.000	A	A	311	0		0.00	311-Jadite
217978	22117	26	0.000	A	A	100	0		0.00	100-Black
241555	22952	26	18.000	A	A	320	0		0.00	320-Fern Green
237062	22040	27	11.000	A	A	106	0		0.00	106-Matte Black
238138	23587	27	11.000	A	A	106	0		0.00	106-Matte Black
217979	22117	28	0.000	A	A	105	0		0.00	105-Textured Black
223093	22601	28	0.000	A	A	980	0		0.00	980-Brushed Aluminum
223128	22602	28	0.000	A	A	980	0		0.00	980-Brushed Aluminum
227544	22880	28	0.000	A	A	980	0		0.00	980-Brushed Aluminum
227579	22881	28	0.000	A	A	980	0		0.00	980-Brushed Aluminum
228599	22952	28	18.000	A	A	370	0		0.00	370-Mint
237063	22040	28	11.000	A	A	206	0		0.00	206-Matte White
238139	23587	28	11.000	A	A	206	0		0.00	206-Matte White
239913	21973	28	0.000	A	A	980	0		0.00	980-Brushed Aluminum
217314	22040	30	11.000	A	A	307	0		0.00	307-Emerald Green
217980	22117	30	0.000	A	A	200	0		0.00	200-White
223074	22601	30	0.000	A	A	605	0		0.00	605-Textured Rust
223109	22602	30	0.000	A	A	605	0		0.00	605-Textured Rust
227525	22880	30	0.000	A	A	605	0		0.00	605-Textured Rust
227560	22881	30	0.000	A	A	605	0		0.00	605-Textured Rust
228600	22952	30	18.000	A	A	380	0		0.00	380-Chartreuse
238113	23587	30	11.000	A	A	307	0		0.00	307-Emerald Green
238870	21947	30	7.000	A	A	ST524	0		1.69	24" Stem - ½" Diameter
217981	22117	32	0.000	A	A	300	0		0.00	300-Dark Green
237166	22880	32	11.000	A	A	106	0		0.00	106-Matte Black
237168	22881	32	11.000	A	A	106	0		0.00	106-Matte Black
237172	22601	32	11.000	A	A	106	0		0.00	106-Matte Black
237174	22602	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
242267	23587	32	11.000	A	A	311	0		0.00	311-Jadite
237167	22880	33	11.000	A	A	206	0		0.00	206-Matte White
237169	22881	33	11.000	A	A	206	0		0.00	206-Matte White
237173	22601	33	11.000	A	A	206	0		0.00	206-Matte White
237175	22602	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
241181	23587	33	11.000	A	A	320	0		0.00	320-Fern Green
217982	22117	34	0.000	A	A	975	0		0.00	975-Galvanized
215458	21947	35	10.000	A	A	ST724	0		2.41	24" Stem - ¾" Diameter
215790	21973	35	0.000	A	A	605	0		0.00	605-Textured Rust
217315	22040	35	11.000	A	A	370	0		0.00	370-Mint
223075	22601	35	11.000	A	A	307	0		0.00	307-Emerald Green
223110	22602	35	11.000	A	A	307	0		0.00	307-Emerald Green
227526	22880	35	11.000	A	A	307	0		0.00	307-Emerald Green
227561	22881	35	11.000	A	A	307	0		0.00	307-Emerald Green
228601	22952	35	18.000	A	A	390	0		0.00	390-Teal
238114	23587	35	11.000	A	A	370	0		0.00	370-Mint
217983	22117	36	0.000	A	A	605	0		0.00	605-Textured Rust
242860	22601	36	11.000	A	A	311	0		0.00	311-Jadite
242864	22602	36	11.000	A	A	311	0		0.00	311-Jadite
237162	21973	37	11.000	A	A	106	0		0.00	106-Matte Black
227362	22872	38	0.000	A	A	100	0		0.00	100-Black
237042	22117	38	18.000	A	A	106	0		0.00	106-Matte Black
237163	21973	38	11.000	A	A	206	0		0.00	206-Matte White
241110	22601	38	11.000	A	A	320	0		0.00	320-Fern Green
241115	22602	38	11.000	A	A	320	0		0.00	320-Fern Green
242019	22880	38	11.000	A	A	320	0		0.00	320-Fern Green
242024	22881	38	11.000	A	A	320	0		0.00	320-Fern Green
227180	21973	39	11.000	A	A	307	0		0.00	307-Emerald Green
217316	22040	40	11.000	A	A	380	0		0.00	380-Chartreuse
223076	22601	40	11.000	A	A	370	0		0.00	370-Mint
223111	22602	40	11.000	A	A	370	0		0.00	370-Mint
227198	22859	40	0.000	A	A	100	0		0.00	100-Black
227363	22872	40	0.000	A	A	105	0		0.00	105-Textured Black
227527	22880	40	11.000	A	A	370	0		0.00	370-Mint
227562	22881	40	11.000	A	A	370	0		0.00	370-Mint
228602	22952	40	18.000	A	A	400	0		0.00	400-Barn Red
237043	22117	40	18.000	A	A	206	0		0.00	206-Matte White
238115	23587	40	11.000	A	A	380	0		0.00	380-Chartreuse
238871	21947	40	12.000	A	A	ST536	0		2.81	36" Stem - ½" Diameter
241560	21973	41	11.000	A	A	320	0		0.00	320-Fern Green
217984	22117	42	18.000	A	A	307	0		0.00	307-Emerald Green
227199	22859	42	0.000	A	A	105	0		0.00	105-Textured Black
227364	22872	42	0.000	A	A	200	0		0.00	200-White
215791	21973	43	11.000	A	A	370	0		0.00	370-Mint
227200	22859	44	0.000	A	A	200	0		0.00	200-White
227365	22872	44	0.000	A	A	300	0		0.00	300-Dark Green
242635	22117	44	18.000	A	A	311	0		0.00	311-Jadite
215460	21947	45	16.000	A	A	ST736	0		3.90	36" Stem - ¾" Diameter
215792	21973	45	11.000	A	A	380	0		0.00	380-Chartreuse
217317	22040	45	11.000	A	A	390	0		0.00	390-Teal
223077	22601	45	11.000	A	A	380	0		0.00	380-Chartreuse
223112	22602	45	11.000	A	A	380	0		0.00	380-Chartreuse
227528	22880	45	11.000	A	A	380	0		0.00	380-Chartreuse
227563	22881	45	11.000	A	A	380	0		0.00	380-Chartreuse
228603	22952	45	18.000	A	A	420	0		0.00	420-Orange
238116	23587	45	11.000	A	A	390	0		0.00	390-Teal
227201	22859	46	0.000	A	A	300	0		0.00	300-Dark Green
227366	22872	46	0.000	A	A	975	0		0.00	975-Galvanized
241100	22117	46	18.000	A	A	320	0		0.00	320-Fern Green
217985	22117	48	18.000	A	A	370	0		0.00	370-Mint
227202	22859	48	0.000	A	A	975	0		0.00	975-Galvanized
227367	22872	48	0.000	A	A	605	0		0.00	605-Textured Rust
241556	22952	48	18.000	A	A	430	0		0.00	430-Soft Clay
215793	21973	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
217986	22117	50	18.000	A	A	380	0		0.00	380-Chartreuse
223078	22601	50	11.000	A	A	390	0		0.00	390-Teal
223113	22602	50	11.000	A	A	390	0		0.00	390-Teal
227203	22859	50	0.000	A	A	605	0		0.00	605-Textured Rust
227529	22880	50	11.000	A	A	390	0		0.00	390-Teal
227564	22881	50	11.000	A	A	390	0		0.00	390-Teal
228604	22952	50	18.000	A	A	470	0		0.00	470-Watermelon
237060	22872	50	11.000	A	A	106	0		0.00	106-Matte Black
238117	23587	50	11.000	A	A	400	0		0.00	400-Barn Red
238872	21947	50	16.000	A	A	ST548	0		3.93	48" Stem - ½" Diameter
217987	22117	52	18.000	A	A	390	0		0.00	390-Teal
237054	22859	52	18.000	A	A	106	0		0.00	106-Matte Black
237061	22872	52	11.000	A	A	206	0		0.00	206-Matte White
217988	22117	54	18.000	A	A	400	0		0.00	400-Barn Red
227368	22872	54	11.000	A	A	307	0		0.00	307-Emerald Green
237055	22859	54	18.000	A	A	206	0		0.00	206-Matte White
215462	21947	55	22.000	A	A	ST748	0		5.39	48" Stem - ¾" Diameter
215794	21973	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
223079	22601	55	11.000	A	A	400	0		0.00	400-Barn Red
223114	22602	55	11.000	A	A	400	0		0.00	400-Barn Red
227530	22880	55	11.000	A	A	400	0		0.00	400-Barn Red
227565	22881	55	11.000	A	A	400	0		0.00	400-Barn Red
228605	22952	55	18.000	A	A	480	0		0.00	480-Blush Pink
238118	23587	55	11.000	A	A	420	0		0.00	420-Orange
217989	22117	56	18.000	A	A	420	0		0.00	420-Orange
227204	22859	56	18.000	A	A	307	0		0.00	307-Emerald Green
242744	22872	56	11.000	A	A	311	0		0.00	311-Jadite
242736	22859	57	18.000	A	A	311	0		0.00	311-Jadite
241101	22117	58	18.000	A	A	430	0		0.00	430-Soft Clay
241172	22040	58	11.000	A	A	430	0		0.00	430-Soft Clay
241182	23587	58	11.000	A	A	430	0		0.00	430-Soft Clay
241974	22859	58	18.000	A	A	320	0		0.00	320-Fern Green
242009	22872	58	11.000	A	A	320	0		0.00	320-Fern Green
215795	21973	60	11.000	A	A	420	0		0.00	420-Orange
217320	22040	60	11.000	A	A	470	0		0.00	470-Watermelon
217990	22117	60	18.000	A	A	470	0		0.00	470-Watermelon
223080	22601	60	11.000	A	A	420	0		0.00	420-Orange
223115	22602	60	11.000	A	A	420	0		0.00	420-Orange
227205	22859	60	18.000	A	A	370	0		0.00	370-Mint
227369	22872	60	11.000	A	A	370	0		0.00	370-Mint
227531	22880	60	11.000	A	A	420	0		0.00	420-Orange
227566	22881	60	11.000	A	A	420	0		0.00	420-Orange
228606	22952	60	18.000	A	A	490	0		0.00	490-Magenta
238119	23587	60	11.000	A	A	470	0		0.00	470-Watermelon
227206	22859	62	18.000	A	A	380	0		0.00	380-Chartreuse
227370	22872	62	11.000	A	A	380	0		0.00	380-Chartreuse
241111	22601	63	11.000	A	A	430	0		0.00	430-Soft Clay
241116	22602	63	11.000	A	A	430	0		0.00	430-Soft Clay
241561	21973	63	11.000	A	A	430	0		0.00	430-Soft Clay
242020	22880	63	11.000	A	A	430	0		0.00	430-Soft Clay
242025	22881	63	11.000	A	A	430	0		0.00	430-Soft Clay
227207	22859	64	18.000	A	A	390	0		0.00	390-Teal
227371	22872	64	11.000	A	A	390	0		0.00	390-Teal
215796	21973	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
217991	22117	65	18.000	A	A	480	0		0.00	480-Blush Pink
223081	22601	65	11.000	A	A	470	0		0.00	470-Watermelon
223116	22602	65	11.000	A	A	470	0		0.00	470-Watermelon
227532	22880	65	11.000	A	A	470	0		0.00	470-Watermelon
227567	22881	65	11.000	A	A	470	0		0.00	470-Watermelon
228607	22952	65	18.000	A	A	495	0		0.00	495-Sherbet Orange
238120	23587	65	11.000	A	A	480	0		0.00	480-Blush Pink
227208	22859	66	18.000	A	A	400	0		0.00	400-Barn Red
227372	22872	66	11.000	A	A	400	0		0.00	400-Barn Red
227209	22859	68	18.000	A	A	420	0		0.00	420-Orange
227373	22872	68	11.000	A	A	420	0		0.00	420-Orange
215797	21973	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
217992	22117	70	18.000	A	A	490	0		0.00	490-Magenta
223082	22601	70	11.000	A	A	480	0		0.00	480-Blush Pink
223117	22602	70	11.000	A	A	480	0		0.00	480-Blush Pink
227533	22880	70	11.000	A	A	480	0		0.00	480-Blush Pink
227568	22881	70	11.000	A	A	480	0		0.00	480-Blush Pink
228608	22952	70	18.000	A	A	500	0		0.00	500-Buttery Yellow
238121	23587	70	11.000	A	A	490	0		0.00	490-Magenta
241975	22859	70	18.000	A	A	430	0		0.00	430-Soft Clay
242010	22872	70	11.000	A	A	430	0		0.00	430-Soft Clay
227210	22859	72	18.000	A	A	470	0		0.00	470-Watermelon
227374	22872	72	11.000	A	A	470	0		0.00	470-Watermelon
227211	22859	74	18.000	A	A	480	0		0.00	480-Blush Pink
227375	22872	74	11.000	A	A	480	0		0.00	480-Blush Pink
215798	21973	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
217993	22117	75	18.000	A	A	495	0		0.00	495-Sherbet Orange
223083	22601	75	11.000	A	A	490	0		0.00	490-Magenta
223118	22602	75	11.000	A	A	490	0		0.00	490-Magenta
227534	22880	75	11.000	A	A	490	0		0.00	490-Magenta
227569	22881	75	11.000	A	A	490	0		0.00	490-Magenta
228609	22952	75	18.000	A	A	570	0		0.00	570-Sunflower
238122	23587	75	11.000	A	A	495	0		0.00	495-Sherbet Orange
227212	22859	76	18.000	A	A	490	0		0.00	490-Magenta
227376	22872	76	11.000	A	A	490	0		0.00	490-Magenta
227213	22859	78	18.000	A	A	495	0		0.00	495-Sherbet Orange
227377	22872	78	11.000	A	A	495	0		0.00	495-Sherbet Orange
215799	21973	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
217994	22117	80	18.000	A	A	500	0		0.00	500-Buttery Yellow
223084	22601	80	11.000	A	A	495	0		0.00	495-Sherbet Orange
223119	22602	80	11.000	A	A	495	0		0.00	495-Sherbet Orange
227214	22859	80	18.000	A	A	500	0		0.00	500-Buttery Yellow
227378	22872	80	11.000	A	A	500	0		0.00	500-Buttery Yellow
227535	22880	80	11.000	A	A	495	0		0.00	495-Sherbet Orange
227570	22881	80	11.000	A	A	495	0		0.00	495-Sherbet Orange
228610	22952	80	18.000	A	A	600	0		0.00	600-Bronze
238123	23587	80	11.000	A	A	500	0		0.00	500-Buttery Yellow
215800	21973	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
217995	22117	85	18.000	A	A	570	0		0.00	570-Sunflower
223085	22601	85	11.000	A	A	500	0		0.00	500-Buttery Yellow
223120	22602	85	11.000	A	A	500	0		0.00	500-Buttery Yellow
227215	22859	85	18.000	A	A	570	0		0.00	570-Sunflower
227379	22872	85	11.000	A	A	570	0		0.00	570-Sunflower
227536	22880	85	11.000	A	A	500	0		0.00	500-Buttery Yellow
227571	22881	85	11.000	A	A	500	0		0.00	500-Buttery Yellow
228611	22952	85	18.000	A	A	601	0		0.00	601-Chocolate
238124	23587	85	11.000	A	A	570	0		0.00	570-Sunflower
241557	22952	88	18.000	A	A	607	0		0.00	607-Taupe
215801	21973	90	11.000	A	A	570	0		0.00	570-Sunflower
217326	22040	90	11.000	A	A	600	0		0.00	600-Bronze
217996	22117	90	18.000	A	A	600	0		0.00	600-Bronze
223086	22601	90	11.000	A	A	570	0		0.00	570-Sunflower
223121	22602	90	11.000	A	A	570	0		0.00	570-Sunflower
227216	22859	90	18.000	A	A	600	0		0.00	600-Bronze
227380	22872	90	11.000	A	A	600	0		0.00	600-Bronze
227537	22880	90	11.000	A	A	570	0		0.00	570-Sunflower
227572	22881	90	11.000	A	A	570	0		0.00	570-Sunflower
238125	23587	90	11.000	A	A	600	0		0.00	600-Bronze
215802	21973	95	11.000	A	A	600	0		0.00	600-Bronze
217327	22040	95	11.000	A	A	601	0		0.00	601-Chocolate
217997	22117	95	18.000	A	A	601	0		0.00	601-Chocolate
223087	22601	95	11.000	A	A	600	0		0.00	600-Bronze
223122	22602	95	11.000	A	A	600	0		0.00	600-Bronze
227217	22859	95	18.000	A	A	601	0		0.00	601-Chocolate
227381	22872	95	11.000	A	A	601	0		0.00	601-Chocolate
227538	22880	95	11.000	A	A	600	0		0.00	600-Bronze
227573	22881	95	11.000	A	A	600	0		0.00	600-Bronze
228613	22952	95	18.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
238126	23587	95	11.000	A	A	601	0		0.00	601-Chocolate
241102	22117	98	18.000	A	A	607	0		0.00	607-Taupe
241173	22040	98	11.000	A	A	607	0		0.00	607-Taupe
241183	23587	98	11.000	A	A	607	0		0.00	607-Taupe
241558	22952	98	18.000	A	A	630	0		0.00	630-Beige
241976	22859	98	18.000	A	A	607	0		0.00	607-Taupe
242011	22872	98	11.000	A	A	607	0		0.00	607-Taupe
215803	21973	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
217998	22117	100	18.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
223088	22601	100	11.000	A	A	601	0		0.00	601-Chocolate
223123	22602	100	11.000	A	A	601	0		0.00	601-Chocolate
227218	22859	100	18.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
227382	22872	100	11.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
227539	22880	100	11.000	A	A	601	0		0.00	601-Chocolate
227574	22881	100	11.000	A	A	601	0		0.00	601-Chocolate
228614	22952	100	18.000	A	A	700	0		0.00	700-Royal Blue
238127	23587	100	11.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
241103	22117	103	18.000	A	A	630	0		0.00	630-Beige
241112	22601	103	11.000	A	A	607	0		0.00	607-Taupe
241117	22602	103	11.000	A	A	607	0		0.00	607-Taupe
241562	21973	103	11.000	A	A	607	0		0.00	607-Taupe
241977	22859	103	18.000	A	A	630	0		0.00	630-Beige
242012	22872	103	11.000	A	A	630	0		0.00	630-Beige
242021	22880	103	11.000	A	A	607	0		0.00	607-Taupe
242026	22881	103	11.000	A	A	607	0		0.00	607-Taupe
215804	21973	105	11.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
217999	22117	105	18.000	A	A	700	0		0.00	700-Royal Blue
223089	22601	105	11.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
223124	22602	105	11.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
227219	22859	105	18.000	A	A	700	0		0.00	700-Royal Blue
227383	22872	105	11.000	A	A	700	0		0.00	700-Royal Blue
227540	22880	105	11.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
227575	22881	105	11.000	A	A	615	0		0.00	615-Oil-Rubbed Bronze
228615	22952	105	18.000	A	A	705	0		0.00	705-Navy
241174	22040	105	11.000	A	A	630	0		0.00	630-Beige
241184	23587	105	11.000	A	A	630	0		0.00	630-Beige
242510	22952	107	18.000	A	A	710	0		0.00	710-Cobalt Blue
241113	22601	108	11.000	A	A	630	0		0.00	630-Beige
241118	22602	108	11.000	A	A	630	0		0.00	630-Beige
241563	21973	108	11.000	A	A	630	0		0.00	630-Beige
242022	22880	108	11.000	A	A	630	0		0.00	630-Beige
242027	22881	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
215805	21973	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
218000	22117	110	18.000	A	A	705	0		0.00	705-Navy
223090	22601	110	11.000	A	A	700	0		0.00	700-Royal Blue
223125	22602	110	11.000	A	A	700	0		0.00	700-Royal Blue
227220	22859	110	18.000	A	A	705	0		0.00	705-Navy
227384	22872	110	11.000	A	A	705	0		0.00	705-Navy
227541	22880	110	11.000	A	A	700	0		0.00	700-Royal Blue
227576	22881	110	11.000	A	A	700	0		0.00	700-Royal Blue
228616	22952	110	18.000	A	A	790	0		0.00	790-Lavender
238128	23587	110	11.000	A	A	700	0		0.00	700-Royal Blue
242636	22117	112	18.000	A	A	710	0		0.00	710-Cobalt Blue
242737	22859	112	18.000	A	A	710	0		0.00	710-Cobalt Blue
242745	22872	112	11.000	A	A	710	0		0.00	710-Cobalt Blue
242637	22117	113	18.000	A	A	715	0		0.00	715-Delphite Blue
242738	22859	113	18.000	A	A	715	0		0.00	715-Delphite Blue
242746	22872	113	11.000	A	A	715	0		0.00	715-Delphite Blue
215806	21973	115	11.000	A	A	705	0		0.00	705-Navy
217330	22040	115	11.000	A	A	705	0		0.00	705-Navy
218001	22117	115	18.000	A	A	790	0		0.00	790-Lavender
223091	22601	115	11.000	A	A	705	0		0.00	705-Navy
223126	22602	115	11.000	A	A	705	0		0.00	705-Navy
227221	22859	115	18.000	A	A	790	0		0.00	790-Lavender
227385	22872	115	11.000	A	A	790	0		0.00	790-Lavender
227542	22880	115	11.000	A	A	705	0		0.00	705-Navy
227577	22881	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
238129	23587	115	11.000	A	A	705	0		0.00	705-Navy
242861	22601	116	11.000	A	A	710	0		0.00	710-Cobalt Blue
242865	22602	116	11.000	A	A	710	0		0.00	710-Cobalt Blue
234295	22601	117	11.000	A	A	790	0		0.00	790-Lavender
242862	22601	117	11.000	A	A	715	0		0.00	715-Delphite Blue
242866	22602	117	11.000	A	A	715	0		0.00	715-Delphite Blue
234296	22601	118	11.000	A	A	800	0		0.00	800-Industrial Grey
234297	22602	118	11.000	A	A	790	0		0.00	790-Lavender
239065	22880	118	11.000	A	A	800	0		0.00	800-Industrial Grey
239066	22881	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
242268	23587	118	11.000	A	A	710	0		0.00	710-Cobalt Blue
234298	22602	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
242269	23587	119	11.000	A	A	715	0		0.00	715-Delphite Blue
215807	21973	120	11.000	A	A	790	0		0.00	790-Lavender
217331	22040	120	11.000	A	A	790	0		0.00	790-Lavender
218002	22117	120	18.000	A	A	800	0		0.00	800-Industrial Grey
223092	22601	120	11.000	A	A	805	0		0.00	805-Charcoal Granite
223127	22602	120	11.000	A	A	805	0		0.00	805-Charcoal Granite
227222	22859	120	18.000	A	A	800	0		0.00	800-Industrial Grey
227386	22872	120	11.000	A	A	800	0		0.00	800-Industrial Grey
227543	22880	120	11.000	A	A	805	0		0.00	805-Charcoal Granite
227578	22881	120	11.000	A	A	805	0		0.00	805-Charcoal Granite
228618	22952	120	18.000	A	A	805	0		0.00	805-Charcoal Granite
238130	23587	120	11.000	A	A	790	0		0.00	790-Lavender
242023	22880	121	11.000	A	A	815	0		0.00	815-Light Grey
242028	22881	121	11.000	A	A	815	0		0.00	815-Light Grey
242867	22602	121	11.000	A	A	810	0		0.00	810-Graphite
241119	22602	122	11.000	A	A	815	0		0.00	815-Light Grey
242512	22952	122	18.000	A	A	810	0		0.00	810-Graphite
242803	22880	122	11.000	A	A	311	0		0.00	311-Jadite
242807	22881	122	11.000	A	A	311	0		0.00	311-Jadite
242863	22601	122	11.000	A	A	810	0		0.00	810-Graphite
241114	22601	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
242804	22880	124	11.000	A	A	710	0		0.00	710-Cobalt Blue
242808	22881	124	11.000	A	A	710	0		0.00	710-Cobalt Blue
215808	21973	125	11.000	A	A	800	0		0.00	800-Industrial Grey
217332	22040	125	11.000	A	A	800	0		0.00	800-Industrial Grey
218003	22117	125	18.000	A	A	805	0		0.00	805-Charcoal Granite
227223	22859	125	18.000	A	A	805	0		0.00	805-Charcoal Granite
227387	22872	125	11.000	A	A	805	0		0.00	805-Charcoal Granite
238131	23587	125	11.000	A	A	800	0		0.00	800-Industrial Grey
242638	22117	126	18.000	A	A	810	0		0.00	810-Graphite
242739	22859	126	18.000	A	A	810	0		0.00	810-Graphite
242747	22872	126	11.000	A	A	810	0		0.00	810-Graphite
242805	22880	126	11.000	A	A	715	0		0.00	715-Delphite Blue
242809	22881	126	11.000	A	A	715	0		0.00	715-Delphite Blue
241104	22117	128	18.000	A	A	815	0		0.00	815-Light Grey
241978	22859	128	18.000	A	A	815	0		0.00	815-Light Grey
242013	22872	128	11.000	A	A	815	0		0.00	815-Light Gray
242806	22880	128	11.000	A	A	810	0		0.00	810-Graphite
242810	22881	128	11.000	A	A	810	0		0.00	810-Graphite
215809	21973	130	11.000	A	A	805	0		0.00	805-Charcoal Granite
217333	22040	130	11.000	A	A	805	0		0.00	805-Charcoal Granite
238132	23587	130	11.000	A	A	805	0		0.00	805-Charcoal Granite
242266	22040	132	11.000	A	A	810	0		0.00	810-Graphite
242270	23587	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
241185	23587	133	11.000	A	A	815	0		0.00	815-Light Grey
241564	21973	133	11.000	A	A	815	0		0.00	815-Light Grey
242513	21973	135	11.000	A	A	311	0		0.00	311-Jadite
242514	21973	137	11.000	A	A	710	0		0.00	710-Cobalt Blue
242515	21973	139	11.000	A	A	715	0		0.00	715-Delphite Blue
242516	21973	141	11.000	A	A	810	0		0.00	810-Graphite
218008	22117	150	160.000	A	A	995	0		0.00	995-Raw Copper
223097	22601	150	93.000	A	A	997	0		0.00	997-Raw Brass
223132	22602	150	93.000	A	A	997	0		0.00	997-Raw Brass
227228	22859	150	160.000	A	A	995	0		0.00	995-Raw Copper
227548	22880	150	93.000	A	A	997	0		0.00	997-Raw Brass
227583	22881	150	93.000	A	A	997	0		0.00	997-Raw Brass
218009	22117	155	200.000	A	A	996	0		0.00	996-Weathered Copper
223098	22601	155	93.000	A	A	998	0		0.00	998-Weathered Brass
223133	22602	155	93.000	A	A	998	0		0.00	998-Weathered Brass
227229	22859	155	200.000	A	A	996	0		0.00	996-Weathered Copper
227549	22880	155	93.000	A	A	998	0		0.00	998-Weathered Brass
227584	22881	155	93.000	A	A	998	0		0.00	998-Weathered Brass
218010	22117	160	250.000	A	A	999	0		0.00	999-Oil-Rubbed Copper
227230	22859	160	250.000	A	A	999	0		0.00	999-Oil-Rubbed Copper
218011	22117	165	210.000	A	A	997	0		0.00	997-Raw Brass
227231	22859	165	210.000	A	A	997	0		0.00	997-Raw Brass
218012	22117	170	250.000	A	A	998	0		0.00	998-Weathered Brass
227232	22859	170	250.000	A	A	998	0		0.00	998-Weathered Brass