select class_instance_id as object_id, department_name, term_name, class_name, pretty_name, url from dotlrn_class_instances_full order by department_name, term_name, class_name, pretty_name select community_id as object_id, pretty_name, url from dotlrn_clubs_full order by pretty_name