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)
Nike Jr. Zoom Mercurial Vapor 15 Academy CR7 IC
Little/Big Kids' Indoor/Court Soccer Shoes
Like Cristiano Ronaldo, azulejo tiles are a Portuguese national treasure. We took visual inspiration from the Portuguese icons and added it to 1 of our fastest Nike Jr. cleats—CR7-approved and laceless for a slip-on fit. The textured design helps with ball control while you shoot at the goal or pass to your teammates. The best part? Zoom Air cushioning under the heel gives you bouncy comfort that lasts your entire game.
The allover, 1-of-a-kind graphic on the upper pays tribute to some of CR7’s past cleats in an azulejo pattern. Cushioned Comfort
Snappy and responsive, Zoom Air cushioning helps provide a quick-off-the-ground sensation. Contain Your Speed
The speed cage inside is made of a thin but strong material that secures the foot to the plate without adding extra weight. All-Weather Touch
A micro texture from heel to toe gives you the touch you need for creativity at high speeds. Dig In, Take Off
Based on analysis of player movements, the rubber outsole is designed to provide multidirectional traction on street, court and indoor surfaces.