[Fixed]-Many to many and how to get a queryset from queryset

You can actually do these things with Django due to it’s lazy queryset evaluation. Django’s in field lookup accepts both lists and querysets. The following will create a nested SQL code:

products = Product.objects.filter(store_set__in=stores_qs)
stores_qs = Store.objects.filter(product__name='product_name')

Here are the Django in docs.

You should be able to filter the stores based on an attribute of Product, and then prefetch_related of the retrieved objects.

Store.objects.filter(product__name="product_name").prefetch_related('product')

This should hit the database the fewest times to achieve what you are looking for – twice.

Further documentation can be found here.

Get Stores with product named “product_name” :

Store.objects.filter(product__name='product_name')

Get all the products except the product with name “product_name”:

Product.objects.exclude(name='product_name')