NuCèlle Mandelic Marine Complex®, is the revolutionary age-defying skin care system that peels away the ravages of time to reveal the secret of a beautiful face — beautiful, healthy, radiant youthful looking skin.
The secret ingredient that will reveal your naturally beautiful skin is NuCèlle's almond-based Mandelic Acid. Physicians have long recognized the powers of this anti-bacterial alpha-hydroxy to treat common skin problems such as photoaging, irregular pigmentation, and acne.
This unique combination provides "Irritation Free" skin conditioning, which is excellent for people with sensitive skin, especially those who are unable to tolerate traditional glycolic acid products. Mandelic Acid is an Alpha-Hydroxy Acid (AHA) primarily found in Almonds, which also exhibits anti-bacterial properties.
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)) as sdesc ,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,prodName,brandName,largeImageURL FROM products left join brands on products.idbrand = brands.idbrand left join (select idproduct,pOrder from categories_products where idcategory = 1312)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(1312) AND active=-1 AND configOnly=0 and removed=0 ORDER BY products.description Asc