select pretty_name, description, url from dotlrn_clubs_full where community_id = :community_id