SELECT c.id as cid, c.title, c.course_description, c.programme_id, c.department_id, c.code, c.unit, c.level, c.semester_id, c.course_type,
		 c.course_description, pc.department_id AS pc_did,
		  pc.programme_id AS pc_pid, pc.course_id AS pc_cid, pc.seen_as_elective, pc.session_id, pc.semester_id AS pc_semester, pc.level AS pc_level, pc.programme_type_id, pc.status
		  FROM courses c, programmes_courses pc
		  WHERE pc.course_id = c.id
		  AND pc.programme_id = '1'
		  AND pc.level = '600'
		  AND pc.programme_type_id = '1'
		  AND pc.session_id = '8'
		  AND pc.status = 1

		  GROUP BY c.id
		  ORDER BY  pc.seen_as_elective ASC, c.code ASC