select user_id, person__name(user_id) as full_name, email from ml_mailing_list_user_map mlum, parties p where list_id = :list_id and subscribed_p = 't' and p.party_id = mlum.user_id