public function index() { $intervals = ClassroomInterval::selectRaw('classroom_intervals.*, COUNT(cs.id) as hasSemesters')->inCurrentSemester()->leftJoin('classroom_sessions as cs', 'cs.interval_id', '=', 'classroom_intervals.id')->groupBy('classroom_intervals.id')->paginate(30); return view('classrooms::intervals.index', compact('intervals')); }