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)
SpeedCELL product – engineered to enhance your speed. The evoSPEED 1.3 PINK is a special edition and one of the lightest boots in the football market. Featuring a redesigned striking PUMA graphic on the medial side, the upper is made of a super soft and ultrathin microfiber material. The Grip-Tex print on the upper enhances ball control in all conditions. Stability and a snug fit in the midfoot is provided by the new external EVERFIT cage. The anatomically engineered lightweight outsole features a PEBAX Speedtrack spine for improved reactivity and torsion ability. The evoSPEED 1.3 features an external heelcounter which secures an excellent heel fit and the PUMA evoAptoLast which provides an industry leading fit. The evoSPEED 1.3 PINK was created as part of a cross category evoSPEED concept, with three things in mind – light, flex & fit.
Upper: super soft and ultrathin microfiber material
Outsole: PEBAX Speedtrack spine for improved reactivity and torsion ability