select count(object_id) 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 select class_instance_id as object_id, department_name, term_name, class_name, pretty_name, url from dotlrn_class_instances_full where class_instance_id in $dotlrn_class order by department_name, term_name, class_name, pretty_name select community_id as object_id, pretty_name, url from dotlrn_clubs_full where community_id in $dotlrn_com order by pretty_name select start_date,end_date from dotlrn_catalog where course_id=:course_id select package_id from cr_folders where folder_id=(select context_id from acs_objects where object_id=:assessment_id)