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 Pro TF
Turf Soccer Shoes
Celebrate the game’s biggest competition in a design motivated by the science of connectivity and gravity that the world stage inspires. Featuring a stunning futuristic look made for the feet of the globe’s greatest players, these shoes have a Zoom Air unit and close-fitting, minimalist material up top so you can dominate in the waning minutes of a match—when it matters most.
Where in the World?
Keep an eye out for special symbols around the design, nods to the host’s whereabouts that pay homage to the game’s grandest worldwide tournament. Nike's WHQ coordinates and emblems that speak to the science of connected energy are near the heel. Welcome to the Field, Zoom
For the 1st time in our history, Nike has developed an all-new Zoom Air unit in the heel. It sits in the outsole and provides an additional springy feel underfoot that helps you move fast on the field and create separation when it matters the most—whether you're scoring goals, being first to the ball or leaving defenders in the dust. 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
Rubber outsole is designed for traction on turf surfaces. 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. Feel the Ball
A comfortable textile upper wraps your foot for a close-fitting feel, leaving only what is truly needed while reducing its weight in the process.