SELECT c.id as cid, c.title, c.course_description, c.programme_id, c.department_id, c.code, c.unit, c.level, c.semester, c.course_type,
		 c.course_description, pc.department_id AS pc_did,
          pc.school_id AS pc_sid, pc.programme_id AS pc_pid, c.course_category,
           pc.course_id AS pc_cid, pc.seen_as_elective, pc.session_id,
           pc.semester AS pc_semester, pc.level AS pc_level, pc.programme_type_id, pc.status,  c.major_status
		  FROM courses c, programmes_courses_nce pc
		  WHERE (c.semester = '1' OR c.semester = '2')
		  AND pc.course_id = c.id
		  AND pc.programme_id = '132'
		  AND pc.level = 'PRE'
		  AND pc.programme_type_id = '1'
          AND pc.status = 0
		  GROUP BY c.id
		  ORDER BY  pc.seen_as_elective ASC, c.code ASC