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. Zoom Mercurial Superfly 9 Academy FG/MG
Little/Big Kids' Multi-Ground Soccer Cleats GO ALL OUT.
You've got the skills and the game, now show it off and slip these Nike Jr. soccer cleats on quick—no laces needed! What's more: Our first-ever Zoom Air unit made for soccer brings extra comfort and bounce to a variety of fields—from real grass to artificial grass. 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 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. Ground Control
Plastic plates with molded studs are designed to work on real grass and artificial grass fields. It's versatile for young athletes who must switch between surfaces.