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)
CR7 SuperflyX 6 Elite (IC) Indoor/Court Football Boot
CR7: THE PRIDE OF PORTUGAL.
The CR7 SuperflyX 6 Elite (IC) Indoor/Court Football Boot wraps your foot with a Flyknit upper and a low-profile Dynamic Fit collar for an all-enveloping, second-skin-like fit. Ronaldo-inspired design pays homage to his crucial role on the Portugal national team.
CR7 details pay homage to Ronaldo’s hero status in Portugal.
Breathable Flyknit upper wraps around the foot for a 360-degree-like feeling.
Zonal NIKESKIN technology enhances touch.
Dynamic Fit collar links the foot and lower leg while allowing ankle room to move.
Herringbone-pattern rubber outsole features tri-star flex grooves for underfoot control.