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)
Nike Jr. Mercurial Vapor 13 Academy Neymar Jr. MG
Kids' Multi-Ground Soccer Cleat FINESSED FOR SPEED. FINISHED FOR NEYMAR JR.
Building on the innovation of the 12, the Nike Jr. Mercurial Vapor 13 Academy Neymar Jr. MG is built for speed. A multi-ground plate delivers takeoff-ready traction, while the textured upper provides a precise touch at high speeds.
Textured for Touch
Soft synthetic material is textured from heel to toe to give you the touch you need for creativity at high speeds. Second-Skin Fit
A comfortable lining wraps your foot to feel like a second skin. Versatile Traction
A versatile multi-ground plate with a Nike Aerotrak zone in the forefoot provides traction on natural- and artificial-grass surfaces.