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)
"If you can't have the last word with your first touch, these football boots are out of your league. Copa helps transform every stroke of your foot into a stroke of genius. The soft K-leather upper helps you orchestrate in comfort, while a moulded vamp brings you closer to the ball for assured control. A stretchy collar wraps around your foot to lock you in while you leave your mark on the game.
Integrated X-Ray vamp cage gives you greater control and reduced ball slippage
Premium K-leather upper provides soft comfort and a silky touch; Structured knit textile collar for a comfortable, sock-like fit
Reduced water absorption
Finished with Fusionskin, an innovative leather treatment that allows for seamless construction and decreased water uptake
Cushioned traction on firm ground
Tough Exoframe plate for supportive traction; TPU Soft Pod inlays provide targeted cushioning at the foot's key pressure points"
Enjoy the comfort and performance of OrthoLite® sockliner