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
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)
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
HAVING sum(e.qoh+e.qc) > 0
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
"Colombia players first pulled on their national team's kit in 1938 for a match against Mexico. Inspired by traditional dress from further back in the country's rich history, this men's football jersey is a version of the away shirt the team will wear in Russia.
Featuring a slightly looser cut and sweat-wicking fabric for comfort, it displays a Colombia crest on the chest. The words ""Unidos por un Pais"" are displayed on the back neck.
adidas is dedicated to creating products in ways that minimise their environmental impact. This jersey is made with recycled polyester to save resources and decrease emissions."
A replica jersey is inspired by what players wear and features a woven crest
Ribbed V-neck with tipping detail; Back neck tape
Woven Colombia crest on chest
Heat-transfer "Unidos por un Pais" graphic below back collar
3-Stripes on shoulders; adidas Badge of Sport on chest