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)
The Future is now more adaptive and more comfortable than ever before, with new updates taking it to its ultimate form. Inspired by Neymar's playstyle, the Future's reengineered mid-cut construction combines fit and agility so you can create without constraints. The FUZIONFIT 360 dualmesh upper features supplemental PWRTAPE support for an even more adaptive, even more supportive fit. Stable at the heel and flexible at the forefoot, the second-generation Dynamic Motions System outsole provides traction and agility for unpredictable changes in direction, leaving you free to move, free to create and free to reach the ultimate version of yourself.
• Upper: dualmesh built with 30% recycled materials
• Fit: FUZIONFIT 360 dualmesh upper features supplemental PWRTAPE support for an even more adaptive, even more supportive fit.
• Touch: Engineered 3D textures at key contact zones are optimized to enhance ball grip and control
• Movement: PUMA’s lightweight Dynamic Motion System outsole is built for explosive pace and acceleration, as well as multi-directional movement