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 distinct(products.idProduct), products.sku, products.description, products.price, products.listhidden, products.listprice, products.serviceSpec, products.bToBPrice, products.imageUrl,products.noprices,products.stock, products.noStock,products.pcprod_HideBTOPrice, 0 as POrder,products.FormQuantity,products.pcProd_BackOrder,brands.IH_showprice,brands.IH_callOrder,brands.callOrderPrice,products.idbrand,disc.discountDesc, CAST(products.sdesc AS NVARCHAR(MAX)) ,products.pcProd_BTODefaultWPrice, products.pcProd_BTODefaultPrice, CASE WHEN showOrder.POrder = 0 THEN 999 WHEN showOrder.POrder is null THEN 999 ELSE showOrder.POrder END as PshowOrder FROM products left join brands on products.idbrand = brands.idbrand left join (select idproduct,pOrder from categories_products where idcategory = 1431)as showOrder on showOrder.idproduct = products.idproduct left join discountsperquantity as disc on disc.idDiscountperquantity = (Select top 1 idDiscountperquantity from discountsperquantity where discountsperquantity.idproduct = products.idproduct and discountPerUnit<>0), categories_products WHERE products.idProduct=categories_products.idProduct AND categories_products.idCategory in(1431,3495,3759,3486,3488,3491,3493,3496,3498,3483,3487,3489,3494,3752,3753,3754,3756,3760,3765,3758,3762) AND active=-1 AND configOnly=0 and removed=0 AND products.idbrand <> 270 ORDER BY products.description Asc