The public defense of the following dissertations will soon take place

select Eindwerk.thID, Onderwerp.Titel_NL, Onderwerp.Titel_FR, Promotor.Naam, Student.Naam, Verdediging.Datum, Verdediging.Uur, Lokaal.Naam, Student.Opleiding, Studierichting.Naam from Onderwerp inner join Eindwerk inner join Student inner join Promotor inner join CurrentStatus inner join Verdediging inner join Lokaal inner join Studierichting where Studierichting.strID = Student.Opleiding and Onderwerp.pID = Promotor.pID and Eindwerk.subID = Onderwerp.subID and Eindwerk.thID = CurrentStatus.thID and CurrentStatus.statID = 90 and Eindwerk.stID = Student.stID and Verdediging.lokID = Lokaal.lokID and Verdediging.thID=Eindwerk.thID and str_to_date(Verdediging.Datum, "%d-%m-%Y") > now() order by Verdediging.Datum, Verdediging.Uur