The ViDerm Philosophy is that every client deserves a tailor-made skin care treatment plan that fits their skin-type, schedule, budget and, most importantly, their desired dermal result.
Vi Derm Skin Care System represent a true breakthrough, rendering other facial skin peels obsolete. These products are safe, simple, practical and painless, with superior results. Clients ultimately achieve "true repair' without hindering their fast paced lifestyle. ViDerms' proprietary formulas give dramatic results with minimal discomfort or downtime and produce dramatic results in less than 30 days. Caring for the skin requires correction and maintenance using the Vi Derm Skin Care System. Enjoy firmer, clearer, more radiant skin, for a healthy, youthful appearance at any age.
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 = 1887)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(1887) AND active=-1 AND configOnly=0 and removed=0 AND products.idbrand <> 152 ORDER BY products.description Asc