select community_type, pretty_name, description, join_policy, portal_id, non_member_portal_id, admin_portal_id, archived_p from dotlrn_communities_all, groups where community_id = :community_id and groups.group_id = community_id