select sc.scorm_course_id as id, o.title, sc.online, sc.default_lesson_mode, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date from scorm_courses sc, cr_folders cf, cr_items ci, acs_objects o where cf.package_id = :package_id and sc.folder_id = cf.folder_id and sc.folder_id = ci.item_id and sc.scorm_course_id = o.object_id [template::list::orderby_clause -orderby -name courses]