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)
Featuring a re-designed suede leather upper and a TPU outsole, the New Balance 442 V2 Academy JNR FG provides the perfect balance between form and function. Premium materials and construction come together to create a kids' soccer cleat that commands respect on the field. A soft internal lining offers a comfortable fit, while firm ground studs provide traction on firm ground surfaces. The 442 V2 marries a classic look with modern performance to help young players stand out on the pitch.
Product Bullets
Upper features a re-designed stitching pattern for a premium hand feel and unparalleled comfort
Premium synthetic upper material
Lightweight TPU plate with TPU stud tips
Firm ground studs for use on firm ground pitches
Comfortable lining to improve the first foot feel
Lace-up closure for a secure fit
Design features a mix of classic and modern New Balance branding