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 Superfly 9 Club FG/MG
Little/Big Kids' Multi-Ground Soccer Cleats
Learning the skills, the game and all the drills? Show how far you've come while rocking the Nike Jr. soccer cleats. Designed for versatility from artificial grass to real grass surfaces, they have the traction you need to run and cut on different types of fields. The durable design will hold up when your schedule is all about practice during the week and games on the weekends.
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. Exceptional Touch
Synthetic leather in the upper upper features small textured details that provide grip for better ball control when dribbling at quick speeds. Dig In, Take Off
Designed for various surfaces, conical studs offer supercharged traction with quick release and pivoting. Seamless Design
A comfortable lining wraps your foot for a natural, close-fitting feel.