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)
Brasil CBF Home Vapor Match Men's Soccer Short-Sleeve Jersey EXTREME COMFORT, ENGINEERED WITH PRIDE.
Brasil CBF Home Vapor Match Men's Football Short-Sleeve Jersey is made with lightweight Dri-FIT fabric that keeps you extremely dry and free to move for the full 90. The design is the same engineered fit as the professional kit, complete with premium applications for Canarinho pride.
Lightweight Dri-FIT fabric for sweat management and ventilation.
V-neck and hem vents allows for full range of motion.
Replica design is the same jersey players wear on the pitch.
Lightweight Brasil CBF team crest is stitched on the left chest. An inner pride label is screen printed behind the crest.
Team pride labels are stitched on the outer back neck and inside the sleeve cuffs.
Laser perforations on the back and shoulder panels enhance breathability. They each have a flat ink, heat-transferred overlay for durability.
Swoosh design trademark is heat-transferred on the right chest.