select department_name, term_name, class_name, pretty_name, description, url from dotlrn_class_instances_full where class_instance_id = :class_id select object_id_two as object_id, rel_type as type from acs_rels where object_id_one = :course_id order by type