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)
Men's Nike F.C. Polo STITCHED WITH F.C. PRIDE.
The Men's Nike F.C. Polo elevates a classic style, made with soft, textured fabric. It features a concealed zipper placket and a slim collar that can be flipped up to flash some F.C. pride.
Soft fabric has a textured surface.
Hidden zipper underneath the placket creates a clean finish.
Slim collar reveals an embroidered "Nike F.C." when flipped up.
Button at the top of the placket is printed with Nike F.C. stars.
Nike F.C. metal emblem is stitched on the left chest.
Dropped hem enhances coverage.
This season's collection is inspired by a city divided by 2 football teams. Split graphics and matte and shiny finishes represent the clash between the 2 sides.