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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike Tiempo Legend 8 Pro FG
Firm-Ground Soccer Cleat PERFECT FIT. LEGENDARY TOUCH.
The Nike Tiempo Legend 8 Pro FG has soft, premium calfskin leather for a legendary touch. A plush lining in the heel hugs your foot, while the sides of the tongue stretch to make it easy to put on your cleats.
Perfect Fit Right Away
The plush microfiber lining in the heel hugs your foot, while the sides of the tongue stretch to make it easy to put on the cleat. Premium Leather Touch
Soft premium calfskin leather is left unstitched with a molded diamond texture for ball control. Stability and Traction
Chevron and modified conical studs give you stability and reliable multidirectional traction on firm-ground fields.