select pretty_name, url from dotlrn_communities_full where community_id = :class_instance_id