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)
The DribbleShield helps young players lift their head up and look around without worrying where the ball is at your feet.
DribbleShield is what youth soccer players in America need in order to reach the next level in soccer. By training with the DribbleShield, players will attain one of the most essential tools needed in the game today, VISION!
Getting Started with DribbleShield:
Familiarize yourself with the way the DribbleShield fits. The fit should be snug. Your first objective is to get comfortable with the idea of movement without being able to see your feet.
Step two, start with touches on the ball. Get a feel for the ball at your feet without being able to see it.
Step three, movement with the ball. Set up a simple dribbling drill, keeping the ball close to your feet.
Step four, once you have mastered keeping the ball at your feet, move on to more advanced drills of passing and receiving the ball.