SELECT ProductLine.ProductLineId, ProductLine.ProductLineName, ProductCategory.ProductCategoryId, ProductCategory.ProductCategoryName, ProductSubCategory.ProductSubCategoryId, ProductSubCategory.ProductSubCategoryName, Products.*,ProductExtendedAttributes.*,ProductTypes.ProductTypeName,Brands.BrandLogoFilePath FROM ProductLine,ProductCategory,ProductSubCategory,Products,ProductExtendedAttributes,ProductTypes,Brands WHERE ProductCategory.ProductLineId = ProductLine.ProductLineId AND ProductCategory.ProductCategoryId = ProductSubCategory.ProductCategoryId AND Products.ProductSubCategoryId = ProductSubCategory.ProductSubCategoryId AND Products.ProductId = ProductExtendedAttributes.ProductId AND ProductExtendedAttributes.ProductTypeId *= ProductTypes.ProductTypeId AND Products.BrandId = Brands.BrandId AND products.skunumber in (SELECT skunumber FROM showcase_products WHERE display = 'Y' and pagetoshow = 'children') ORDER BY products.productname

<<< Previous #productstoshowperpage# Products Next #productstoshowperpage# Products >>>   PRODUCT NAME SIZE RETAIL PRICE OUR PRICE YOU SAVE BUY No image #productname# #UnitCount# #ProductTypeName# #DollarFormat(MSRP)# #DollarFormat(UnitPrice)# #DecimalFormat(yousavepercentage)#% #UnitCount# #ProductTypeName# #DollarFormat(MSRP)# #DollarFormat(UnitPrice)# #DecimalFormat(yousavepercentage)#% <<< Previous #productstoshowperpage# Products Next #productstoshowperpage# Products >>>

The following products that keep Vitacost.com's CEO's son healthy, are available to you with just one click! Consider This... One example of the benefits of providing children with optimal nutrition is the story of Vitacost.com's CEO's son. Fred is almost seven years old and is very healthy not only now but has been for the last seven years. What does this mean? Fred has never needed or used an antibiotic and has never had an ear infection or sinusitis. Fred is at his ideal weight, is full of energy and mentally is very healthy and happy. How was this accomplished? Explaining to Fred that soda, candy and fast food is very bad for you and makes you sick and further explaining the foods that make you healthy. This encourages him to drink orange juice, spring water, tea and eat fish, broccoli, green peas, green beans, apples, 100% organic whole grain pancakes/waffles and other healthy foods. Explaining to Fred that vitamins make you healthy. Fred takes a natural multivitamin/mineral supplement (most mass market products are junk and contain really bad sweeteners, fillers and colors and even worse contain pitifully low levels and the worst forms of essential nutrients), a extra calcium/magnesium supplement (the levels in the diet and multi are inadequate alone), a probiotic (this means prolife and promotes a healthy digestive flora) and Ester-C (a superior form of vitamin C that is retained longer and better absorbed).