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 Manchester City FC Squad Men's Long-Sleeve Football Top
MANCHESTER PRIDE. BIG MATCH ATTITUDE.
With a print inspired by topographic maps of club cities, the Nike Dry Manchester City FC Squad Men's Long-Sleeve Football Top brings speed, style and performance fit to the training pitch. Raglan sleeves and hem vents eliminate restrictions to optimize mobility during drills, scrimmages and warm-ups.
Manchester City FC crest and colors show your team pride.
Topographic maps inspired the “Hunting Grounds” abstract pattern in an allover embossed graphic.
Nike Dry fabric helps you stay dry, comfortable and focused.
Performance fit creates a fast look and feel.
Angle-cut hem vents allow for cooling on the pitch.