SELECT *, Products.SKUNumber FROM LowCarbProducts (nolock), Products (nolock) WHERE LowCarbFeatured = 1 AND LowCarbActive = 1 AND LowCarbProducts.LowCarbSKUNumber = Products.SKUNumber AND Products.Hidden = 'N' AND (Products.Discontinued = 'N' OR (Products.Discontinued = 'Y' AND Products.StatusMessage = 'Coming Soon')) ORDER BY LowCarbOrder SELECT * FROM LowCarbCategories (nolock) WHERE LowCarbCategoryActive = 1 ORDER BY LowCarbCategoryOrder SELECT DISTINCT Brands.BrandId, Brands.BrandName FROM Brands (nolock), Products (nolock) WHERE Products.BrandId = Brands.BrandId AND Products.SKUNumber IN (SELECT LowCarbSKUNumber FROM LowCarbProducts WHERE LowCarbActive = 1) AND Products.Hidden = 'N' ORDER BY Brands.BrandName

		Welcome Health Shop Customers! Vitacost.Com has recently acquired Healthshop.Com. You were buying products at discount, now experience purchasing your products at wholesale! 33%-75% cheaper than retail! If you have any questions or problems finding a product, our customer service staff is here to help you. (800) 793-2601 . Click HERE to receive our FREE newsletter! Whatever your dieting needs, Vitacost carries the top brands for healthy weight loss and maintenance.   ---> #Chr(60)#/tr> #Chr(60)#tr>#Chr(60)#/tr> #Chr(60)#tr> #Chr(60)#/tr> #Chr(60)#tr>#Chr(60)#/tr> #Chr(60)#tr> #lchq_GetCategories.LowCarbCategoryName[lchq_GetCategories.CurrentRow - (i-1)]# #lchq_GetBrands.BrandName# SELECT wdArticleID,wdArticleTitle,wdArticleLink FROM ArticlesWalkerDiet WHERE wdArticleActive = 1 AND wdArticleIsAdvice = 0 ORDER BY wdArticleSortNumber,wdArticleTitle SELECT wdArticleID,wdArticleTitle,wdArticleLink FROM ArticlesWalkerDiet WHERE wdArticleActive = 1 AND wdArticleIsAdvice = 1 ORDER BY wdArticleSortNumber,wdArticleTitle #wd_Advices.wdArticleLink#wdarticle.cfm?articleid=#wd_Advices.wdArticleID#" class="ArticlesLink">#wd_Advices.wdArticleTitle# #wd_Articles.wdArticleLink#wdarticle.cfm?articleid=#wd_Articles.wdArticleID#" class="ArticlesLink">#wd_Articles.wdArticleTitle#