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 Mercurial Superfly 7 Elite FG Firm-Ground Soccer Cleat FINESSED FOR SPEED.
Building on the 360 innovation of the 6, the Nike Mercurial Superfly 7 Elite FG adds a Nike Aerow Trac zone to the forefoot and a slightly stiffer chassis to help supercharge traction.
High-Tenacity Fit
360-degree Flyknit construction wraps your foot for a second-skin fit. New high-tenacity yarn and a 1-piece lining create a close, secure feel on the field. All-Weather Touch
A new ultra-thin NIKESKIN overlay gets you closer to the ball for high-speed maneuvers. The All Conditions Control (ACC) finish means you get reliable touch in wet and dry conditions. Explosive Acceleration
The lightweight forefoot plate features a Nike Aerow Trac zone with micro grooves. The angular studs combine with a new stiffer chassis for explosive acceleration with every step.
More Details
Dynamic Fit collar wraps your ankle for secure comfort.
Insole with NikeGrip technology provides maximum traction underfoot and lightweight cushioning.
Firm-ground (FG) cleats are best for use on slightly wet short-grass fields.
