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)
It temporary relieves muscle aches and joint pains associated with arthritis, minor backache, tendonitis, muscle overuse, stress injuries and strains. This remarkablly unique and effective formulation boasts three key ingredients. The first is menthol which has long been recognized in the medical community as a potent and fast-acting pain relieving drug. The second is the herb Ilex, which is extracted from a holly shrub grown in South America and used by the Paraguayan Indians. The third is the utilization of cryotherapy or 'cold therapy", the application of cold to decrease inflammation and relieve pain. It is widely accepted in the medical community that cold therapy is an effective treaent to help reduce daily aches and pains. Completely greaseless, with a vanishing scent. For your added convenience it's available in gel, roll-on or spray.