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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Lightweight flask is designed to fit right in your hand while being easy to squeeze. The fully adjustable hand strap paired with a no-slip, no-sweat insert allows for stress and grip-free running. Double-wall construction keeps fluids cooler 20% longer than other insulated bottles.
Updated high flow Push-Pull Blast Valve™ cap has a quicker rebound to keep you hydrated on the go. Ergonomic design features 360 degrees of reflectivity and stash pockets for carrying keys or cards.
Ergonomic flask designed to be easier to squeeze
Fully-adjustable hand strap with chafe-free thumb hold enables grip-free running
Sweat-channeled, no-slip grip insert for an easier carry
Updated high flow Push-Pull Blast Valve™cap has a quicker rebound to keep you hydrated on the go
360 degrees of reflectivity
Double-wall construction keeps fluids cooler longer than a non-insulated bottle
94% Polyester, 6% Spandex
Hand Wash Only
We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shippingis available in checkout for a shipping premium.
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:
8970 Kingsridge Dr.
Dayton, OH 45458