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. Mercurial Zoom Superfly 9 Academy KM IC
Little/Big Kids' Indoor/Court Soccer Shoes
Play fast, play relentless and feel like superstar Kylian Mbappé on the field with the Nike Jr. soccer shoes. You got the skills and the game—now slip these on quick—no laces needed—and show it all off. Our first-ever Zoom Air unit made for soccer brings extra comfort and bounce to indoor courts and the streets. With the stamp of approval from one of the world's best, who's ready to sub in?
Welcome, Zoom!
For the first time in our history, Nike has developed an all-new, soccer-specific Air Zoom unit in the heel. The unit sits in the plate and provides an extra level of responsive cushioning. Quick to Wear
Pull tabs and stretchy fabric help you open the shoe up wide so your feet can easily slip in and stay snug. Crisscrossing straps help give an extra level of support and a secure feel while you play. Built to Last
Synthetic leather provides durability so the shoes hold up for games and practices. A mesh collar adds extra support and breathable comfort. Court Control
Non-marking rubber outsole gives great traction for wood or vinyl gym floors or outdoor street surfaces.
