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 Furon V7 Destroy FG soccer cleat is designed for the player who craves a distraction-free fit. Featuring a lightweight knit upper with mesh lining and a comfortable knit collar with tongue tab for added grip, this cleat delivers breathability, comfort and a clean finish. Off-set lacing provides increased strike zone and lockdown. Optimized for firm ground play, the TPU outsole with chevron stud configuration offers incredible feel and feedback. Simplicity at its finest.
Lightweight knit upper with mesh lining for a clean finish
TPU outsole designed specifically for firm ground use
Chevron stud configuration
Off-set lacing with cored-out canopy to increase strike zone
Knit collar for a lightweight and breathable feel
Tongue tab for added grip
Flying NB wrap-around logo with multi-tone heel graphic