Django - Filtering Out Already Rated Restaurants In Yelp Like App

Consider the following database model: class User: id = models.BigAutoField(primary_key=True) first_name = models.CharField(max_length=50) last_name = models.C

Solution 1:

You could filter them starting with restaurants

restaurant_ids = Rating.objects.filter(by_user=user).values_list('for_profile__by_restaurant', flat=True).distinct()
eligible_restaurants = Restaurant.objects.exclude(id__in=restaurant_ids)

Note: this will generate only one query because django's querysets are lazy.