GM Collin skin care line was founded in France in 1957 by Dr. Eugénia Lapinet, a dermatologist and pioneer in the use of collagen pellicules, and Monique Moreau, a renowned professional aesthetician. Since 1991, the G.M. Collin dermo-corrective skin care line has been developed and manufactured by Dermo-Cosmetik Laboratories in Montreal, Canada. Initially, the scientific team reformulated existing formulas to adapt them to the North American climate, and throughout the years, they have developed an array of new products derived from recent technologies. Research and Development is a major part of the G.M. Collin chemists’ daily program as they systematically work on continued improvements and innovative 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 = 32)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(32,33,35,36,37,38,54,56,57,58,59,149,150,151,152,238,1616,2936,2921,3266,3265,153,154,155,156,157) AND active=-1 AND configOnly=0 and removed=0 AND products.idbrand <> 270 ORDER BY products.description Asc