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 Mercurial Vapor 15 Academy KM MG
Multi-Ground Soccer Cleats
Kylian Mbappé's explosiveness, plus his twitchy change of direction, puts him firmly in the world class of finishers. With nods to his heritage, this cleat is made to help you play just like KM—with blinding pace and purpose. We added a Zoom Air unit and grippy texture up top for exceptional touch, so you can dominate in the waning minutes of a match—when it matters most.
Welcome to the Field, Zoom
For the first time in our history, Nike has developed an all-new Zoom Air unit. It sits in the plate and provides an additional level of springy underfoot feel that helps you move faster on the field and create separation when it matters the most—whether you're scoring goals, being first to the ball or going by defenders. Drive Your Speed
The speed cage inside of the structure is made of a thin but strong material that secures the foot to the outsole without adding additional weight for optimal lockdown. Dig In, Take Off
Unique traction pattern offers supercharged traction with quick release to create separation. Improved Fit
A redone design improves the fit, so that it better simulates the foot. We did this by conducting multiple wear tests on hundreds of athletes. The result is a more contoured toe box and better lockdown in the heel. Barefoot Feel
The upper has NikeSkin, a soft and flexible mesh material linked together by a thin coating. It helps provide ball control and truly gives you a feeling of barefoot soccer.