select 1 from category_object_map where object_id = :course_id select tree_id from category_tree_map where object_id = :cc_package_id select object_id_two as object_id, rel_type as type from acs_rels where object_id_one = :course_id order by type