Dr. Renaud products CAN ONLY be shipped within North America. No store discounts or promotionals sales are applicable to Dr. Renaud products.
Since 1947 Laboratoire Dr Renaud have offered a totally natural concept in treatment skincare and make-up using only the finest natural plant and marine extracts. Dr Renaud offers solutions for all skincare problems even the most sensitive. Dr Renaud care products are mainly created with naturally-derived ingredients, giving preference to: certified organic ingredients, fair trade, biodiversity awareness while excluding from formulations unwanted chemical ingredients or products. Resulting in many products without: Parabens, Synthetic Colorants, Synthetic Perfume, Mineral Oil. There is no animal testing on products.
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 = 824)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(824,894,895,896,897,898,899,2392,2926,2927,2928,2929,3239,3238) AND active=-1 AND configOnly=0 and removed=0 AND products.idbrand <> 270 ORDER BY products.description Asc