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 Zoom Fly 4
Men's Road Running Shoes DURABLE SPEED MADE FOR PROPULSIVE TRAINING.
Train hard and find your rhythm on the road. From the moment you lace up, the webbing on the upper and lacing system wrap around your foot for a secure feel from start to finish. The added flex feels highly responsive and secure with every step. A soft, breathable upper combines with a stretchy collar for a sock-like fit for a secure, stable sensation. You've got goals to hit, lace up and fly towards a new best.
Nike Flyknit material is placed around the collar, providing extra stretch for easy on and off. It has a sock-like feel that helps contain your foot and feels secure. Cooler Comfort
The upper is made with lightweight mesh for a softer, more breathable feel that conforms to your foot. Secure Feel
Midfoot support arrives courtesy of 4 individual pieces of webbing that intertwine with the laces. When you lace up, the shoe gets tighter, giving you stability. Also, an internal heel pod delivers a more secure fit than the Zoom Fly 3. Propulsive Miles
Nike React technology is a lightweight, durable foam that delivers a smooth, responsive ride. It combines with an internal carbon fiber plate for flexibility in your stride.
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