session.query(User, Participant).filter(Participant.team_id==32).\
    filter(User.user_id==Participant.pool_member_id).all()

ProgrammingError: (ProgrammingError) table name "resources" specified more than once
'SELECT resources.resource_id AS resources_resource_id, resources.resource_type AS resources_resource_type, users.user_id AS users_user_id, users.firstname AS users_firstname, users.lastname AS users_lastname, users.email AS users_email, users.hashed_password AS users_hashed_password, users.summary AS users_summary, users.history AS users_history, users.hobbies AS users_hobbies, users.quote AS users_quote, users.url AS users_url, users._work_phone AS users__work_phone, users._home_phone AS users__home_phone, users._cell_phone AS users__cell_phone, users.primary_phone_location AS users_primary_phone_location, users.im_handle AS users_im_handle, users.p_program_owner_id AS users_p_program_owner_id, users.image_id AS users_image_id, users.locked AS users_locked, users.change_password AS users_change_password, users.last_login AS users_last_login, participants.participant_id AS participants_participant_id, participants.participant_type_id AS participants_participant_type_id, participants.team_id AS participants_team_id, participants.pool_member_id AS participants_pool_member_id \nFROM resources JOIN users ON resources.resource_id = users.user_id,\
## resources
JOIN participants ON resources.resource_id = participants.participant_id \nWHERE participants.team_id = %(team_id_1)s AND users.user_id = participants.pool_member_id' {'team_id_1': 32}