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 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.USBlock = 0 AND brands.IDBrand in (256) group by CASE When prodGroupItems.prodgroupID is null then cast(newID() as varchar(255)) ELSE cast(prodGroupItems.prodgroupID as varchar(255)) END