Cacher is the code snippet organizer for pro developers

public function get_curriculum_course_other_details($curriculumID)
        {
                return $this->db
                ->select('a.*,c.name as "className",b.name as "title"')
                ->from('curr_courses a')
                ->join('other_courses b', 'a.class = b.id', 'left')
                ->join('other_depts c','b.other_dept_id = c.id', 'left')
                ->where('a.curriculum_id', $curriculumID) 
                ->where('a.flag_other', 1) 
                ->order_by('a.year asc, a.term asc')
                ->get();
        }