Algologie products are concentrated in powerful marine active ingredients that helps to effectively prevent first signs of aging. Agolgie's main ingredient is from pure concentrate of Christie Marine's stem cells, Caniculata. Caniculata is a brown seaweed that deeply moisturize, restore radiance, and visibly reduce wrinkles. Products are paraben-free, silicon-free, mineral oil-free, phthalate and propylene glycol-free. Algogie Research Laboratory have developed the Algo Complex. Algo Complex has active ingredients to remineralize, moisturize, and to protect skin from free radicals.
select min(USID) as idProduct, min(USprice) as price, max(USprice) as maxPrice, max(USlistprice) as listPrice, min(description) as description, min(prodName) as prodName , min(inventory.USimageUrl) 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(US_callOrder) as IH_callOrder, min(US_showPrice) as IH_ShowPrice, min(US_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(USTreshHold) 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 USActive = 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 USID <>0 and USActive= 1 AND brands.IDBrand in (5) group by CASE When prodGroupItems.prodgroupID is null then cast(newID() as varchar(255)) ELSE cast(prodGroupItems.prodgroupID as varchar(255)) END