fixing pending/confirmed bookings query to pull only non-cancelled data