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 Pro FG Firm-Ground Football Boot SPEED RIB SWIFT.
The micro-textured, premium synthetic upper of Men's Nike Superfly 6 Pro FG Firm-Ground Football Boot wraps underneath your foot for a second-skin-like fit. A 2-part podular plate system utilizes chevron studs for speed in every step, while embossed speed ribs from heel to toe make your boot look as fast as you feel.
Micro-textured, premium synthetic upper creates a second-skin-like feeling.
All Conditions Control (ACC) provides high-speed touch on wet or dry pitches.
Podular plates mirror foot's shape and provide responsive traction.
Embossed speed ribs flow from toe to heel.
Perforations in heel lining provide breathability.
Flyknit Dynamic Fit Collar links the foot and lower leg while leaving the ankle free to move.
Chevron studs facilitate bursts of speed and quick stops.
Synth Lthr
Text (100% Polyester)