select community_type, pretty_name, dotlrn_communities_all.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 select enabled_p as member_email_enabled_p from dotlrn_member_emails where community_id = :community_id and type = 'on join'