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)
Unisex shoe based on men's sizing. For women, order 1.5 sizes down (ex. for a women's 8.5, order a unisex 7.0)
Nike ZoomX Streakfly
Road Racing Shoes LIGHT SPEED.
Our lightest racing shoe, the Nike ZoomX Streakfly is all about the speed you need to take on the competition in a mile, 5k or 10k race. Low profile with sleek details, it feels like it disappears on your foot to help you better connect with the road on the way to your personal best.
Low and Nimble
A full-length ZoomX midsole provides the ultimate lightweight responsiveness. The foam stack heights are lower than the Vaporfly, saving weight and giving you a more aggressive feel. It results in a shoe so light, it disappears on your foot while still giving you the responsive protection of ZoomX foam, helping you reach your fastest pace throughout the turns and accelerations of any race. Supportive and Sleek
An ultra-thin knit upper is light in weight while still providing the support you need for racing. Extra reinforcement in the forefoot keeps you secure. The updated, sleek lacing system is laterally offset with a notched tongue to help relieve pressure on the top of the foot. Grip Where It Counts
Runner-informed data was used to create the outsole. It uses that information to place traction where you need it the most, with a pattern that connects to the pavement based on how your foot hits the ground. The result is solid grip from foot contact to toe-off, helping you stay ahead of the competition.
Partially integrated tongue delivers a secure fit.
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