select pretty_name, url from dotlrn_communities_full where community_id = :class_id select community_id as id from dotlrn_communities_full