this can be one query.

    User.query.join(User.activation).options(eager_load(User.activation)) 

or something like that. Check the other queries for joined examples.