Error in SQL to build QuerySet. A Model with multiple ForeignKeyField referring to the same model.

Describe the bug

class Range(Model):
    min = fields.ForeignKeyField("models.Value", null=True, related_name="range_min")
    max = fields.ForeignKeyField("models.Value", null=True, related_name="range_max")


class Value(Model):
    value = fields.IntField()

min = await Value.create(value=1)
max = await Value.create(value=5)
await Range.create(min=min, max=max)
    
# Get the Value of the Range containing 3.
values = await Value.filter(Q(range_min__max__value__gt=3, 
                              range_max__min__value__lt=3, 
                              join_type="OR"))

# Expect: 
#     Two Values are returned
# Result: 
#    Only the first `range_min` specified in Q is returned.
assert 2 == len(values)

Generated queries.

SELECT "value"."id","value"."value"
FROM "value"
    LEFT OUTER JOIN "range" ON "value"."id"="range"."min_id"
    LEFT OUTER JOIN "value" "range__max" ON "range__max"."id"="range"."max_id"
    LEFT OUTER JOIN "value" "range__min" ON "range__min"."id"="range"."min_id"
WHERE "range__max"."value">3 OR "range__min"."value"<3

Queries to expect.

SELECT "value"."id","value"."value"
FROM "value"
    LEFT OUTER JOIN "range" ON "value"."id"="range"."min_id" OR "value"."id"="range"."max_id"
    LEFT OUTER JOIN "value" "range__max" ON "range__max"."id"="range"."max_id"
    LEFT OUTER JOIN "value" "range__min" ON "range__min"."id"="range"."min_id"
WHERE "range__max"."value">3 OR "range__min"."value"<3

Start with the Range and Value model definitions, the Value.filter query, and the generated SQL in the issue. Reproduce the query with both ForeignKeyField relations pointing to Value and inspect how the OR condition is translated into joins. Done means the generated join condition matches the expected SQL and the query returns both matching Values.