Updated: How to span multile tables in Django for a backwards relationship

Question

The Django documentation gives en example like so:

b = Blog.objects.get(id=1)
b.entry_set.all()

Which from what I understand results in 2 queries. What if I wanted to get the blog, the blog entries and all the comments associated with that entry in a number of queries that does not depend on the number of entries? Or do I have to drop down to SQL to do that?

Answer 1

Blog.objects.select_related(...).get(id=1)