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)
More adaptive and comfortable than ever, the advanced FUTURE is a progressive and explosive boot for players who shape the game to their vision and skill.
You don’t have to lace up to lock in. The second-generation FUZIONFIT+ technology adapts to the shape of your foot to give you the perfect balance of support and flexibility in each of the key zones, ensuring optimal fit and performance, with or without laces.
The lightweight and reactive Dynamic Motion System outsole transfers your energy directly onto the pitch, providing superior traction for explosive multidirectional movements.
Advanced Creator Zones are strategically positioned in the forefoot area to deliver exceptional touch and ball control at high speed.
- Super lightweight Dynamic Motion System outsole provides freedom of movement and support for dynamic changes of movement. Suitable for use on both firm natural surfaces and artificial grass (4G).
- Highly technical and flexible engineered upper with integrated FUZIONFIT+ technology provides exceptional fit and lock-in, with or without laces. Advanced Creator Zones include a textured 3D grip zone on the lateral side for enhanced driving and cutting of the ball, while the medial side features a more open, softer pattern for refined touch and control during passing and finishing.