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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Men's Nike Superfly 6 Elite FG Firm-Ground Football Boot 360 DEGREES OF SPEED.
The Flyknit upper of Nike Superfly 6 Elite FG Men's Firm-Ground Football Boot wraps underneath your foot for an all-enveloping, second-skin-like fit straight out of the box. The 2-part podular plate system utilizes a lightweight internal chassis that flexes for speed with every step.
1-piece upper with Dynamic Fit collar wraps under the foot for an adaptive fit.
Micro-textured Flyknit construction provides touch at high speeds.
Podular plate system with internal chassis flexes for propulsive traction.
Low-profile Dynamic Fit collar links the foot and lower leg.
All Conditions Control (ACC) technology provides optimal ball control.
Heel lining and NIKEGRIP top cloth minimize internal movement.
Chevron studs provide traction on firm-ground pitches.