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,3)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
"This jersey keeps Real Madrid fans in the comfort zone while their club's sparkling football keeps them at the top. Built with silky, sweat-wicking fabric, it has a slightly looser fit than the ones the players wear on the pitch. Reflecting the Spanish club's creative spirit, adidas has joined forces with Parley for the Oceans in this shirt's creation. It features yarn spun from plastic intercepted from beaches and coastal communities before it reaches our oceans.
Climalite wicks sweat to keep you dry in every condition
Made for fans
A fan jersey is a streetwear version of what players wear on match day and is wider in the shoulders and body
Good for the oceans
This product is created with yarn made in collaboration with Parley for the Oceans: Some of the yarn features Parley Ocean Plastic™, which is made from recycled waste, intercepted from beaches and coastal communities before it reaches the ocean"
Lightweight fabric with a silky feel
Sweat-wicking Climalite fabric; "For the oceans" on back neck tape
Embroidered Real Madrid crest; "RMCF" on upper back
This jersey is made with recycled polyester to save resources and decrease emissions