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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike F.C. Tribuna
Men's Fleece Full-Zip Soccer Hoodie
On our Tribuna Hoodie, lightweight warmth courtesy of soft French terry brings on-field comfort to your daily routine. Premium details, like the multi-language "Nike Football" graphic down the zipper, celebrate the culture of soccer.
Comfort Beyond the Field
When we think of soccer, we think of the joy of watching our favorite team from the best seats with our fellow supporters, celebrating the highs and lows of the game. We used that mindset to create the Tribuna collection. It celebrates that on-field revelry by bringing the culture of soccer to your days outside the stadium. With luxe, comfortable details, it's like a VIP section for comfort. Light and Smooth
French terry fabric has a soft feel for lightweight comfort—like your classic sweatshirt.
Ribbed cuffs and hem
Nike F.C. flag label
Body and Hood Lining: 80% cotton/20% polyester. Rib: 98% cotton/2% spandex.