class UserVote(TimeStampedModel):
event = models.ForeignKey('events.Event')
fightchoice = models.ForeignKey('fights.FightChoice')
user = models.ForeignKey(User)
class UserEvent(TimeStampedModel):
event = models.ForeignKey('events.Event')
user = models.ForeignKey('users.User')
user_season_events = UserEvent.objects\
.filter(event__season=season_id, user=request.user.id, user__uservote__user=request.user.id)\
.order_by('-event__event_on') \
.select_related('event')\
.values('event', 'user__uservote__fightchoice__points', 'user__uservote__event',
'user__uservote__fightchoice__howitended', 'user__uservote__fightchoice__fighter')
SELECT "users_userevent"."event_id", "fights_fightchoice"."points", "users_uservote"."event_id", "fights_fightchoice"."howitended_id", "fights_fightchoice"."fighter_id"
FROM "users_userevent"
INNER JOIN "events_event" ON ( "users_userevent"."event_id" = "events_event"."id" )
INNER JOIN "users_user" ON ( "users_userevent"."user_id" = "users_user"."id" )
LEFT OUTER JOIN "users_uservote" ON ( "users_user"."id" = "users_uservote"."user_id" )
LEFT OUTER JOIN "fights_fightchoice" ON ( "users_uservote"."fightchoice_id" = "fights_fightchoice"."id" )
WHERE ("events_event"."season_id" = 1 AND "users_userevent"."user_id" = 199 AND "users_uservote"."user_id" = 199 ) ORDER BY "events_event"."event_on" DESC
I want:
LEFT OUTER JOIN "users_uservote" ON "users_user"."id" = "users_uservote"."user_id" )
to be (on events_event not users_user) like this:
LEFT OUTER JOIN users_uservote ON events_event.id = users_uservote.event_id
When I added 'user__uservote__event' to the values in my queryset should it not create it?
Thank you for you help.