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 min(USID) as idProduct, min(USprice) as price, max(USprice) as maxPrice, max(USlistprice) as listPrice, min(description) as description, min(prodName) as prodName , min(inventory.USimageUrl) 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(US_callOrder) as IH_callOrder, min(US_showPrice) as IH_ShowPrice, min(US_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(USTreshHold) 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 USActive = 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 USID <>0 and USActive= 1 AND brands.IDBrand in (175) group by CASE When prodGroupItems.prodgroupID is null then cast(newID() as varchar(255)) ELSE cast(prodGroupItems.prodgroupID as varchar(255)) END