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,3)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Show your colours and support your team with the Official Licensed kit of the Uruguayan Football Federation.
The Pure White jersey is the very pinnacle of elegance, simplicity and style.
Official Uruguayan Football Federation woven crest with embroidered outline on left chest, Uruguayan flag sign off heat transfer in back neck yoke, LA CELESTE as heat transfer in the inside back neck. Embroidered PUMA Cat Brandings on right chest and both sleeves; mesh structured Formstripe on shoulders; raglan sleeve construction; contrasted ribbing colours in the back and the front of the crew neck collar, engineered jacquard graphic on front panel, double knit bio-based wicking finish, Official Licensed secondary branding heat transfer
Material: Main Material 1: 100% polyester ; double knit; 150.00 g/m²; finish: bio-based wicking finish
Rib: 100% polyester ; cirk knit 1x1; 220.00 g/m²