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 on these laceless boots helps you create 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.
Control the ball at high speed with a Purecut laceless sock forefoot with no edges, overlays or laces to get between you and the ball; Integrated X-Ray vamp cage gives you greater control and reduced ball slippage
Premium K-leather upper provides soft comfort and a silky touch; A stretchy adidas Primeknit collar for adaptive support, ultralight comfort and ease of entry
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