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 Zoom Vapor 15 Club 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've got the skills and the game, so slip these on quick—no laces needed—and show it off! What's more: Our first-ever Zoom Air unit made for soccer brings extra comfort and bounce to the field, like your indoor gym and the streets. With the stamp of approval of one of the world's best like Mbappé, who's ready to sub in?
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 secure feel while you play. Built to Last
Synthetic leather provides durability so the shoes hold up for games and practices. A breathable collar adapts to your fit for extra support and breathability. Court Control
Non-marking rubber outsole gives traction for wood or vinyl gym floors or outdoor street surfaces.