postgresql7.4 SELECT s.semester_id, s.name, s.start_date, s.end_date FROM cc_semester s WHERE package_id = :package_id [template::list::orderby_clause -orderby -name "semesters"]