Django selecting related objects many levels deep

Question

I have these 4 tables in Django:

• Stores (id)
  • Products (id, store_id)
  • Orders (product_id, customer_id)
• Customers (id)

A Store has many products, a product has many orders and an order has one product and one customer.

How would I query in Django to retrieve the distinct list of customers per store? I could easily do it with an SQL query but I would really prefer to go the ORM way.

Answer 1

If you have a Store already fetched:

customers = Customer.objects.filter(order__product__store=store)