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 V3+ Magique FG soccer cleats are ideal for the intelligent and calculated player whose sole purpose is to win. Featuring a redesigned Kinetic Stitch construction that offers durability and flexibility, this soccer cleat also boasts technology-driven zonal support and strategic 3D embroidery for impressive agility and control. Providing an amplified sensation underfoot, these cleats let you feel exactly what the ball is doing. Plus, a molded and removable insert brings plush comfort to the mix during long, grueling games. See the game differently in Tekela.
Product Bullets
Redesigned Kinetic Stitch construction adds support where it's needed without compromising flexibility
Integrated Hypoknit upper designed to provide strategic areas of stretch and support. Full-foot stretch knit upper provides unrivaled stability, while a re-engineered knitted collar improves ease of entry and fit
TPU film for supreme stability and touch; 3D print in forefoot and 3D embroidery in strike zones for control
TPU plate with inlayed nylon chassis
Firm ground cleat combination to deliver rotational traction on firm surfaces
Laced closure with high collar for secure lock-down and stability
Molded, removable EVA insert for underfoot comfort
Multifunctional zones provide feedback from shoe to player
Engineered for control and accuracy
Oversized N on lateral side, New Balance wordmark logo on medial side