SELECT Class.id AS id, 
Class.module_id AS moduleId, 
Module.name AS moduldeName 
FROM Class 
INNER JOIN Module ON Module.id = Class.module_id 
INNER JOIN Semester ON Semester.id = Class.semester_id 
INNER JOIN StudentClass ON StudentClass.class_id = Class.id
WHERE StudentClass.user_id = 1 AND 
curdate() BETWEEN Semester.startDate AND Semester.endDate;
Add custom select query for selecting class for a student
Add custom select query for selecting class for a student
