In formulating its exclusive facial and body care preparations, DR. GRANDEL relies first and foremost on carefully selected raw materials and active ingredients taken directly from nature, which then undergo sophisticated processing in our production stages. The result is a line of top-quality cosmetics that are highly effective and extremely well tolerated – and that easily rank with very best in the world. All DR. GRANDEL skin and body care products are produced in accordance with original recipes at our state-of-the-art plant in Augsburg, Germany – where even the essential wheat germ-based raw materials are made in-house.
DR. GRANDEL cosmetics are produced in line with stringent quality guidelines similar to the regulations governing the manufacture of pharmaceuticals. The strict application of hygienic and process controls also helps to keep the use of preservatives to a minimum. The result is made-in-Germany top quality.
DR. GRANDEL cosmetics are tested on human volunteers, always in collaboration with leading dermatologists – and never in animal experiments.
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 (74) group by CASE When prodGroupItems.prodgroupID is null then cast(newID() as varchar(255)) ELSE cast(prodGroupItems.prodgroupID as varchar(255)) END