Men's BOA Stretch 3

Men's BOA Stretch 3" 1/2 Split

Style: 1206SWP

Brand: boa

$40.95

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	ORIGATTR1	QOH	SKU_ID	SORT_ORDER
1	DONUTS	46603	[empty string]	[empty string]	DONUTS	4	476288	[empty string]
2	FLAMINGO_TURQUOISE	46604	[empty string]	[empty string]	FLAMINGO_TURQUOISE	6	476294	[empty string]
3	GONE_BANANAS	46605	[empty string]	[empty string]	GONE_BANANAS	3	476306	[empty string]
4	MONEY	46607	[empty string]	[empty string]	MONEY	8	476318	[empty string]
5	TACO!	46610	[empty string]	[empty string]	TACO!	5	476336	[empty string]
6	GALAXY	46611	[empty string]	[empty string]	GALAXY	6	476300	[empty string]
7	USA	46612	[empty string]	[empty string]	USA	7	124826	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 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) 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 HAVING sum(e.qoh+e.qc) > 0 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	10950

Color: donuts / flamingo turquoise / gone bananas / money / taco! / galaxy / usa

Size: S M L

description
shipping & returns

The BOA 3” Stretch Half Split Trainer features BOA's new Hybrid Lite stretch fabric and added length for increased modesty. The fabric incorporates spandex allowing for 4-way stretch to eliminate all bind and creates an ultra-soft feel. Half side splits allow full range of motion and coverage. Elastic waistband and draw cord provide adjustability for your perfect fit. Sleek internal key pocket built into waistband. If you are looking for high performance with added coverage, this is the short for you.

Shell - Hybrid Lite, 88/12 Micro Polyester/Spandex, Lining - 100% Polyester
Ultra-Lightweight stretch fabric provides extra soft flexible performance while keeping you dry during your runs.
Half side split for full range of motion and high performance
3” inseam for added coverage and modesty
Elastic waistband with built in drawstring and key pocket
Designed, Cut, Sewn, and Printed in the USA

Shipping

We offer free standard shipping on all orders $65+ 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. Damaged or defective items can also be returned for a full refund within 90 days. Please contact us with any inquiries.

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