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)
Talk won't take you to the top. Victory won't make you a champion. Many win the game. Only the great leave their mark. While the good take victory, the great inspire it. Made for players with guts and grace, these football boots have premium leather in the forefoot for an elite first touch. The Sprintframe plate gives you unmatched stability to outclass the competition on firm ground.
Premium K-leather in the forefoot for supreme comfort and feel
Integrated X-Ray vamp cage gives you greater control and reduced ball slippage
Foam heel pads offer unmatched comfort; Enjoy the comfort and performance of OrthoLite® sockliner; Moulded footbed
Sprintframe plate offers the perfect balance between light weight and stability
Conical studs aligned for smooth ground penetration; Arched midfoot for increased stability