fetch attendance booked in future, more query work