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)
Uhlsport patented ABSOLUTGRIP goalkeeper glove for best gripping properties in all weather conditions. Best in dry conditions but is a great all weather game option as well. Goalkeeper should dampen the latex to increase grip and durability.
Patented BIONIK FRAME protection technology for advanced stabilization of the 4 fingers and outstanding distribution of the impact forces without limiting the flexibility. Inspired by the best structural engineer of all time Mother Nature the BIONIKFRAME is designed to mimic and enhance the natural arrangement and operation of the musculature of the human hand. The result: Stable. Flexible. Lightweight. Bionik frame technology is a close imitation of the human hand and finger tendons. It is a lightweight, flexible, impact distribution frame built into the backhand of the glove which. For those keepers that require support but find the plastic finger stays found in other manufacturers to be too rigid and hard to close the hand or catch a ball.
Special embossed, abrasion resistant backhand parts for better durability. This Uhlsport goalkeeper glove has a soft latex backhand with an embossed latex shockzone area for punching. Breathable textile base material for outstanding wearing comfort.
The Uhlsport Absolutgrip Bionik is a classic cut for a wider palm and more comfortable fit. Ergonomically pre-curved for best wearing characteristics. The 12° angle on the wrist supports the ergonomical hand position for perfect catching performance. The classic cut is better for goalkeepers with wider hands but will offer extreme comfort for all keepers.
Full wrap latex strap with neoprene glove body opening.
Superb game option for high school and college level goalkeepers
This absolutgrip latex performs well in all weather condi