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)
gloveglu glove care essentials pack features all of your favourite gloveglu products in 50ml bottles. PLUS a Glove Care Guide and gloveglu stickers.
The ideal pack for travel, for the game, or simply as an introduction to three of our core products. Contains:
PREMIUM GLOVEWASH & PREPARE 50ML
Enhance the performance and longevity of your latex with the scientifically formulated glove wash & prepare. Removes dirt from the latex area of the goalkeeping glove for enhanced play and longer life.
Keep your gloves smelling fresh and odour free. glovefresh works directly on the odour producing bacteria, eliminating them and the unpleasant smell.
Revive your old gloves. Improve your new.
gloveglu enhances the grip of any goalkeeping glove with its unique formula.
Can be applied before or during the game and is equally effective in wet or dry conditions.
Suitable for any type of goalkeeping glove palm.
Glove Care Guide leaflet with advice on how to look after your gloves.
"gloveglu gripping sports stuff" and "GET A GRIP“ sticker.