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 premium leather upper and an elite-level nylon outsole, the New Balance 442 V2 Pro FG provides the perfect balance between form and function. High-performance materials and construction come together to create a soccer cleat that commands respect on the field. Internal cushioned pillows deliver uncompromising comfort, while firm ground studs provide traction on firm ground surfaces. The 442 V2 marries a classic look with pro-level performance to help you stand out on the pitch.
Upper features a re-designed stitching pattern with twin needle articulation for a premium hand feel and unparalleled comfort
Premium leather upper material
Elite-level nylon plate to reflect modern high-performance needs
Firm ground studs for use on firm ground pitches
Grippy synthetic suede lining to improve the first foot feel and deliver on comfort and performance
Engineered fused and padded tongue
Supportive inner cushioned pillows for improved fit and effortless comfort
Lace-up closure for a secure fit
Design features a mix of classic and modern New Balance branding