Founded by internationally-recognized dermatologist, Dr. Jason K. Rivers, and run locally in British Columbia, RIVERSOL skin care products address the needs of the urban, cutting edge customer by delivering superior quality AND proven effects. In 1999, after having practiced medicine for almost 20 years, Dr. Rivers realized that many of his patients were confused about the ingredients and effectiveness of products available in the rapidly expanding skin care market. In early 2000, Dr. Rivers began to focus his interest on thujaplicin, an ingredient derived from the Pacific Red Cedar tree. He came to the realization that as a strong anti-oxidant with other therapeutic properties, thujaplicin was perfect for reducing the look of wear and tear on the skin.
select min(CAID) as idProduct, min(CAprice) as price, max(CAprice) as maxPrice, max(CAlistprice) as listPrice, min(description) as description, min(prodName) as prodName , min(inventory.CAimageUrl) 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(CA_callOrder) as IH_callOrder, min(CA_showPrice) as IH_ShowPrice, min(CA_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(CATreshHold) 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 CAActive = 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 CAID <>0 and CAActive= 1 AND brands.IDBrand in (294) group by CASE When prodGroupItems.prodgroupID is null then cast(newID() as varchar(255)) ELSE cast(prodGroupItems.prodgroupID as varchar(255)) END
0 Products Found
No products found for these filters.
Please try changing some filters to see other products, or call us at 1-866-336-7546(SKIN)