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
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike Dry FC Barcelona Squad Men's Long-Sleeve Football Top
BIG MATCH ATTITUDE. TEAM PRIDE.
With a graphic print inspired by the team's biggest matches in Europe, Nike Dry FC Barcelona Squad Men's Long-Sleeve Football Top brings speed, style and a performance fit to the training pitch. Raglan sleeves and hem vents eliminate restrictions to allow for optimal mobility during drills, scrimmages and warm-ups.
FC Barcelona crest and colors show your team pride.
Striped graphic takes inspiration from the team's biggest matches in Europe.
Nike Dry fabric helps you stay dry, comfortable and focused.
Collar has taped external seams for a smooth feel against the skin.
Raglan sleeves eliminate the shoulder seam to allow a natural range of motion.