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)
Since launch in 2012, the RESPONSEBALL has become the most recognised goalkeeper specific training ball around the World. Having been used in some of the biggest clubs and associations, including Manchester City, Liverpool, Barcelona and the English FA, we now bring you their latest release.
A premium quality PU ball with a butyl bladder for better air retention, RESPONSEBALL has its own specifically developed internal weight system to provide unique, irregular movement when in flight and in contact with any surface. At home equally on astro or grass, kicked or thrown, the RESPONSEBALL delivers unpredictable bounce movements to keep your goalkeepers on their toes!
The RESPONSEBALL is ideal for any keeper, any age, playing at any level, for use in training reactions, movement, shot-stopping, making saves or just for adding a little something different into your session. A great addition to any coaches bag.