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
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)
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)
CR7 Superfly 6 Elite (FG) Men's Firm-Ground Football Boot
CR7: THE PRIDE OF PORTUGAL.
The Flyknit upper of CR7 Superfly 6 Elite (FG) Men's Firm-Ground Football Boot wraps underneath your foot for an all-enveloping, second-skin-like fit with Ronaldo-inspired design. A 2-part podular plate system flexes for propulsive speed at every step.
1-piece upper with Dynamic Fit collar wraps under foot for an adaptive fit.
Micro-textured Flyknit construction provides touch at high speeds.
Podular plate system with internal chassis flexes for propulsive traction.
CR7 details pay homage to Cristiano Ronaldo’s hero status in Portugal.
All Conditions Control (ACC) technology optimizes ball control in wet and dry weather.
Perforated heel lining with a suede-like finish grips the foot and helps hold the boot in place.
Chevron studs facilitate bursts of speed and quick stops on firm-ground pitches.
NIKESKIN technology adds durability while maintaining flexibility.