"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,\n\t\t c.course_description, pc.department_id AS pc_did,\n\t\t  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\n\t\t  FROM courses c, programmes_courses pc\n\t\t  WHERE c.semester_id = '1'\n\t\t  AND pc.course_id = c.id\n\t\t  AND pc.actual_programme_id = '4'\n\t\t  AND c.level = '600'\n\t\t  AND pc.programme_type_id = '1'\n\t\t  AND pc.status = 0\n\n\t\t  GROUP BY c.id\n\t\t  ORDER BY  pc.seen_as_elective ASC, c.code ASC  \n    "