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)
The New Balance Tekela V4 Magia FG soccer cleat lets you see and feel the game differently. It features a full-foot stretch-knit upper with minimal texture and weight to bring you closer to the ball, plus a laceless closure for secure lockdown. The lightweight nylon outsole with multi-directional conical stud configuration helps you perform on firm ground surfaces, while the bold and oversized graphics make sure you look good doing it.
Full-foot stretch-knit upper with minimal texture and weight to bring you closer to the ball
Laceless closure for secure lockdown and stability
3D knit collar for grip and ease of entry
Seam-free off-set instep zone for lockdown and reduced pressure
Lightweight nylon outsole designed for use on firm ground
Multi-directional conical stud configuration
Heel graphic and NB logo with oversized N logo on lateral side
Textured emboss details on lateral and medial sides