Discovered in 1736, Avene's thermal spring water has been used to effectively treat serious dermatological conditions such as atopic dermatitis, psoriasis, eczema and burns.
Over 150 clinical studies demonstrate the soothing properties of Avene thermal spring water. Its unique composition makes Avene thermal spring water ideally suited for the care and management of sensitive skin.
Dermatological hydrotherapy utilizes the therapeutic properties of natural spring water to address a variety of skin disorders. The unique composition of Avene thermal spring water in conjunction with the treatment techniques offered at the Avene Hydrotherapy Center have been proven beneficial in alleviating dermatological conditions including atopic dermatitis, psoriasis, eczema and burns.
select min(CAID) as idProduct, min(CAprice) as price, max(CAprice) as maxPrice, max(CAlistprice) as listPrice, min(description) as description, min(prodName) as prodName , min(inventory.CAimageUrl) as imageURL, sum(sold365) as sales, min(prodGroupItems.prodGroupID) as prodGroupID, min(gCount.groupCount) as groupCount, min(prodGroups.divider) as divider, min(prodGroups.name) as groupName, sum(count) as count , avg(avgstars) as avgstars, min(CA_callOrder) as IH_callOrder, min(CA_showPrice) as IH_ShowPrice, min(CA_CAllOrderPrice) as callOrderPrice, min(brands.idbrand) as idbrand, min(brands.brandName) as brandName, min(freezes) as freezes, min(aerosol) as aerosol, min(leaks) as leaks, min(podeclined) as podeclined, max(freeGiftID) as freeGiftID, max(CATreshHold) as treshHold FROM [dbo].[inventory] left join brands on brands.idbrand = inventory.idbrand left join prodGroupItems on prodGroupItems.itemID = inventory.itemID left join prodGroups on prodGroupItems.prodGroupID = prodGroups.prodGroupID left join (select prodGroupId, count(prodGroupID) as groupCount from prodGroupItems left join inventory on inventory.itemID = prodGroupItems.itemID Where CAActive = 1 group by prodGroupID) as gCount on gCount.prodGroupId = prodGroups.prodGroupID left join (SELECT itemID, COUNT(stars) AS COUNT, round(cast(SUM([stars]) as float)/COUNT([stars]) *2,0)/2 AS avgstars FROM pcReviews WHERE active=1 group by itemID) as reviews on reviews.itemID = inventory.itemID left join freegifts on freeGifts.itemID = inventory.itemID WHERE [inventory].[active]=-1 and CAID <>0 and CAActive= 1 and brands.CABlock = 0 AND brands.IDBrand in (21) group by CASE When prodGroupItems.prodgroupID is null then cast(newID() as varchar(255)) ELSE cast(prodGroupItems.prodgroupID as varchar(255)) END