super.sessionFactory.getCurrentSession().createQuery(
			"select * from Appointment as appointment" +
			"where appointmentId in" +
			"(select appointment.appointmentId, MAX(timeSlot.startDate)" +
			"from Appointment as appointment" +
			"inner join TimeSlot as timeSlot" +
			"where appointment.patient = :patient)"
			).setParameter("patient", patient).uniqueResult();