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)
Nike Tiempo Legend 8 Elite FG
Firm-Ground Soccer Cleat PERFECT FIT FOR LEGENDARY TOUCH.
The Nike Tiempo Legend 8 Elite FG takes the legendary touch of premium kangaroo leather and adds foot-hugging Quad-Fit mesh in the lining and a wraparound Flyknit tongue that feels supportive under your arch.
A Quad-Fit mesh lining hugs your foot for a comfortable feel right out of the box. The Flyknit tongue wraps under your arch for a supportive feel. Premium Leather Touch
The soft premium kangaroo leather is left unstitched for a touch unlike any other. A textured forefoot and All Conditions Control (ACC) technology give you control in wet and dry conditions. Stable Traction
The lightweight Hyperstability plate gives you stability and reliable multidirectional traction on firm-ground fields. NikeGrip technology on the sockliner helps lock your foot in place within the cleat.