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)
Limited release. Excessive quantities and orders will be canceled.
Nike ZoomX Dragonfly
Racing Spike MADE TO FLY.
Light and breathable with a bounce to every step. The Nike ZoomX Dragonfly delivers the speed you need to stand out from the pack in races from 1,500 to 10,000 meters. Details throughout celebrate the power of sport rising to the challenge of the moment.
This special edition colorway celebrates unity as athletes worldwide emerge from the year's past events to compete. It's a celebration of sport, humanity and our ability to push through the toughest of challenges. Celebrate the Swoosh
The Swoosh celebrates its 50th anniversary by intertwining the past and present. The original Swoosh is outlined over the current version, representing the path Nike has taken from yesterday to today. Fast, Efficient Energy Return
Nike ZoomX foam is incredibly responsive and lightweight, delivering optimal energy return and impact protection for your miles. Light and Race Ready
Lightweight mesh means breathability and support made to go the distance. Ridged Design
The forefoot plate was created using data from hundreds of runners. It helps ensure a smooth transition from toe-off to heel strike.
Detachable stainless steel spikes
World Athletics approved
Weight: 4.4oz (Men's size 8/Women's size 10)
Based off of men's sizing. For women, order 1.5 sizes down (i.e. for a women's 8.5, order the unisex 7.0)
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