SELECT
    AppointmentID,
    AttendanceDate,
    AppointmentStage
FROM tbAppointments
WHERE ClientID = @nClientID
  AND (AppointmentStage = 'Appointment' OR AppointmentStage = 'AuthReady')
  AND AttendanceDate >= NOW()
ORDER BY AttendanceDate