Cannot annotate two different ReverseRelation

class Player(Model):
    id = fields.IntField(pk=True)
    id_player_score_f: fields.ReverseRelation["Score"]
    id_player_score_s: fields.ReverseRelation["Score"]

class Score(Model):
    id = fields.IntField(pk=True)

st = Player.all().annotate(mf=Max("id_player_score_f__id"),ms=Max("id_player_score_s__id")).sql()

or

st = Player.all().annotate(mf=Max("id_player_score_f__id")).annotate(ms=Max("id_player_score_s__id")).sql()

Results in:

SELECT "players"."id", MAX("scores"."id") "mf", MAX("scores"."id") "ms" FROM "players" LEFT OUTER JOIN "scores" ON "players"."id"="scores"."f_id" GROUP BY "players"."id"

Expected:

SELECT "players"."id", MAX("scores1"."id") "mf", MAX("scores2"."id") "ms" FROM "players" LEFT OUTER JOIN "scores1" ON "players"."id"="scores1"."f_id" LEFT OUTER JOIN "scores2" ON "players"."id"="scores2"."s_id" GROUP BY "players"."id"

Start with the Player/Score reproducer and the Player.all().annotate(...).sql() entry point. Trace how each ReverseRelation path becomes a join, comparing the generated SQL with the expected separate aliases and f_id/s_id joins. Done when combined and chained annotations generate both distinct joins, with regression coverage for these cases.