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 Trail Second Sunrise
Men's 5" Brief-Lined Trail Shorts
Designed for trail running, these sweat-wicking shorts set you up for taking the long route. We designed them using insights from trail runners like you, with a breathable feel and a shape that helps keep you moving on those epic runs. We know you want to bring your outdoor essentials with you, so we added plenty of pockets—as in 7 pockets—to keep all your gear close and secure.
Stay-Dry Support
Nike Dri-FIT technology moves sweat away from your skin for quicker evaporation, helping you stay dry and comfortable. Cool Comfort
Breathable woven fabric feels smooth and cool. Side vents were designed with the trail athlete in mind, giving you room to move as you navigate the outdoors. A brief liner adds breathable support without hindering motion. Safe Storage
With 7 pockets to choose from, you'll have plenty of storage. The 2 drop-in pockets can hold a key or card. 2 larger side pockets and 2 zippered hand pockets can hold pre- and post-run gear, and the back pocket is big enough to hold a phone.
Designed for Trail Running
Length: 5"
Liner: Brief
Fabric: Lightweight woven
Storage: 2 drop-in pockets, 2 large side pockets, 2 zippered hand pockets and a big back pocket
Waistband: Compression
Not intended for use as Personal Protective Equipment (PPE)
Shipping
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
