Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ProgramTypeID = 1) and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ProgramTypeID = 2) and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ProgramTypeID = 3) and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ProgramTypeID = 4) and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ProgramTypeID = 6) and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ProgramTypeID = 7) and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ProgramTypeID = 8) and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ProgramTypeID = 10) and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Select count(*) from wp_miles_programs p where p.Active ='1' and (p.DateCreated >= '2015-03-29') and (p.ExpirationDate >= now() or p.ExpirationDate is null or p.ExpirationDate = '0000-00-00' or p.ExpirationDate = '1969-12-31' )
Programs Listed on this Site
(Click Each to View National Listings)

Schools with Salad Bars595
Schools participating in the Fresh Fruit & Vegetable Program7
Schools with Fruit & Veggie Vending Machines245
Schools with Wellness Policies2
Grocery Stores with Fruit & Veggie Activities13
Business with Fruit & Veggie Contests1
Business with Fruit & Veggie Promotions4
Farmers' Markets5366
All Programs8663
Program Profiles added in the past 30 Days0

Connect & follow