more query efficient - gets all day in a single query