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)
There’s nothing like working up a good sweat. On the flip side, for many people, there’s nothing that can spoil a workout quicker than foul smelling sports equipment that sparks fears of germs and serious health risks.
Fortunately there’s a solution that’s safe, affordable, environmentally friendly and effective; it’s “Fresh Gear" from Fresh Gear, Inc.
Fresh Gear is the solution to environmental and human caused odors in everything from shoes and gloves to sports equipment and mascot costumes. “Fresh Gear” is a product that should be in every household, every office, every sports bag, car and SUV.
“Fresh Gear” is a combination of proprietary ingredients including disinfectaning alcohol, third generation odor encapsulation and a pleasant scent. The exclusive combination eliminates malodors and freshens gear for long lasting odor elimination not available in competing products.