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)
Smile. You’re on a highlight reel, and the whole world is watching. Inspired by Neymar Jr., the FUTURE 1.4 combines the second-generation FUZIONFIT+ technology and the all-new Advanced Creator Zones so you can create without constraints throughout the 90 minutes.
Second-generation FUZIONFIT+ knitted upper locks you in for a snug, supportive fit, letting you play with or without laces.
Advanced Creator Zones on the forefoot are engineered to enhance ball grip and control for dribbling, passing, and finishing.
Asymmetric Dynamic Motion System outsole enables quick changes of pace and direction.
The PUMA FUTURE 1.4 Neymar Jr Dream Chaser FG/AG Soccer Cleat will be on display in Qatar.