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 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 = 1505)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(1505,2712,2753,3256,2066,2067,2069,2075,2080,2071,2073,2070,2065,2072,2074,2076,2078,4028,4710) AND active=-1 AND configOnly=0 and removed=0 AND products.idbrand <> 152 ORDER BY products.description Asc