Women's CEP Calf Sleeves 3.0

Style: WS40

Brand: cep

$39.95

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	NON_INVT	ORIGATTR1	QOH	SKU_ID	SORT_ORDER
1	BLACK/DARK_GREY	46774	[empty string]	[empty string]	N	BLACK/DARK_GREY	3	477061	[empty string]
2	ICE/GREY	46775	[empty string]	[empty string]	N	ICE/GREY	-1	477066	[empty string]
3	ROSE/LIGHT_GREY	46776	[empty string]	[empty string]	N	ROSE/LIGHT_GREY	5	477071	[empty string]
4	WHITE/DARK_GREY	46777	[empty string]	[empty string]	N	WHITE/DARK_GREY	0	477076	[empty string]
5	Black	46778	[empty string]	[empty string]	N	BLACK	0	154136	0
6	Pink	46779	[empty string]	[empty string]	N	PINK	0	154137	0
7	White	46780	[empty string]	[empty string]	N	WHITE	0	154138	0

CACHED

false

EXECUTIONTIME

SQL

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(z.non_invt) as non_invt FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) LEFT JOIN tb_styles z on (z.style_id = a.style_id) WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(1,2,3) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	12422

Colors:

Size: I II III IV V

description
shipping & returns

Precision fit for a compact effect. CEP Calf Sleeves 3.0 offer improved compression and stabilization. The new sleeves also incorporate high-tech yarn and moisture management tech to promote fast evaporation and rapid cooling on hot days. A great combination with CEP Short Socks, Low Cut Socks, or No Show Socks, these sleeves are perfect for runners and triathletes as well as endurance and teamsport athletes.

Compression effect and stabilization throughout the entire calf
Optimum performance thanks to targeted medi compression

Size (Calf Circumference)
2 (9.5-12 in / 25-31 cm)
3 (12.5-15 in / 32-38 cm)
4 (15.5-17.5 in / 39-44 cm)
5 (18-20 in / 45-50 cm)

Shipping

We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shipping is available in checkout for a shipping premium.

Returns

Any unworn product can be returned for a full refund within 90 days. We do not offer free return shipping except in cases of defective items. These can be returned for a full refund within 90 days at no expense to you. Please contact us with any inquiries.

Returns can be mailed to:
Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458