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 IC
Little/Big Kids’ Indoor/Court Soccer Shoes
Learning the skills, the game and all the drills? Show how far you've come while wearing the Nike Jr. soccer shoes. Made for indoor and court games, they have the traction you need to run and cut on gym floors—plus street courts. The durable design will hold up when it's time to practice and play those games of pickup.
Contain Your Speed
The speed cage is made of a thin but strong material that secures the foot to the plate without adding extra weight. Exceptional Touch
Synthetic leather upper features small textured details that provide grip for better ball control when dribbling at quick speeds. Dig In, Take Off
Rubber outsole is designed for great traction on court surfaces. Seamless Design
A comfortable lining wraps your foot for a natural, close-fitting feel.
Non-marking rubber soles with traction patterns designed for wood or vinyl gym floors or outdoor street surfaces, typically for small-sided or pickup play.