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)
Nike Swoosh On The Run
Women's Medium-Support Lightly Lined Sports Bra with Pockets
Feel confident and go all out—without having to leave anything behind—in this medium-support sports bra. 3 mesh-lined pockets hold your phone, a snack or an extra layer so you can explore without limits. The lightweight, sewn-in spacer lining feels breathable while still giving you a little coverage, and sweat-wicking tech helps you keep your cool on the run.
Storage You Can Count On
Lefties rejoice! 2 angled side pockets keep your phone in place while allowing easy access–no matter your dominant hand. Breathable mesh lines the pocket bags to keep you cool and the sweat off your belongings. An additional bungee pocket at the racerback allows for snack or phone stashing on your long runs. Stay Dry
Nike Dri-FIT technology moves sweat away from your skin for quicker evaporation, helping you stay dry and comfortable. More Room to Go
A fully detachable pack provides extra storage for long hikes or outdoor adventures. Carry the pack on a day trip or attach it to your bra while you're on the move.
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.
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