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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
New Balance VISARO PRO FG - GALAXY/BRIGHT CHERRY. Now your young one can control the game with ease with the Visaro Pro Junior. Made for the player who controls the game with exceptional ball retention and creative distribution. Be the one to unlock the defense and stand out with the new color of the Visaro. Slice through defenders in the 4mm Ariaprene mesh upper, PU bonded top layer, debossed 2mm "Sweetspot," asymmetrical internal heel counter, burrito tongue for maximum ball control, lightweight nylon outsole with polished TPU "Rotation Zone," and biomechanical stud placement all sitting atop the revolutionary Fresh Foam footbed to move you toward your goal: the other guys' goal.UPPER: Vari-zone Ariaprene synthetic for ball control.Low pressure zone instep for instant control.Pro-form last for feel and comfort.Fresh Foam insock for cushioning.OUTSOLE: Superflex soleplate for ground contact.Medial Pivot Zone for quick turns.WEIGHT: 8.2 oz.