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)
Kit yourself out with pitch-perfect pride in a replica version of Manchester City's third shirt, which is used for international competitions like the Champions League. Made using recycled fibres, it's sleek, sophisticated and sustainable too. Featuring raglan sleeves for freedom of movement and dryCELL moisture-wicking technology to keep you cool and comfortable when the action heats up, plus perfect pops of pigment print and cool contrasting cuffs, you'll be supporting your squad with stadium-ready style.
FEATURES & BENEFITS
dryCELL: PUMA's designation for moisture-wicking properties that help keep you dry and comfortable
Contains Recycled Material: Made with recycled fibers. One of PUMA's answers to reduce our environmental impact.
Ribbed crew neck
Raglan sleeve construction with mesh shoulder panel inserts