SELECT a.title,a.sub_code,b.*,c.name as loc_name,a.description from courses as a join schedule as b on a.id=b.course_id join location as c on b.location=c.id where b.id = 312BEGIN:VCALENDAR VERSION:1.0 BEGIN: VEVENT DTStart:20220925T000000 DTEnd:20220929T000000 Location;ENCODING=QUOTED-PRINTABLE:Dubai UID:20220925T00000020220929T000000 DESCRIPTION;ENCODING=QUOTED-PRINTABLE:


SUMMARY;ENCODING=QUOTED-PRINTABLE:Gence Course Reminder PRIORITY:1 End:VEVENT End:VCALENDAR