Django manytomany and through pair

I have django models with a manytomany connection with a through class:

class userProfile(models.Model):
    boughtCoupons = models.ManyToManyField(Coupon, through='UserCoupons')

class UserCoupons(m开发者_运维问答odels.Model):
    user = models.ForeignKey(userProfile)
    coupon = models.ForeignKey(Coupon)
    date = models.DateField()


class Coupon(models.Model):
    name = models.CharField(max_length=10)

I know how I can get each of them individually using and ID or something to filter.

But, I need to get the Through table's value with all the user's details (profile).

So how can I do something like a JOIN, and get a UserCoupons + userProfile pair in a single query ? ( So I can get the matching user profile without an extra query ?)

---

You can query directly on UserCoupons and use select_related() to fetch also the related objects in one query:

UserCoupons.objects.select_related().filter(**your_filters)

Note that select_related() doesn't work "backwards". That's why you need to use a manager of the class that defines the ForeignKey to make it work (UserCoupons in this case).

---

If you are using Django 1.2 or less version then jkbrzt's answer is the only solution as far as I know, since the only way to get Django to generate JOINs, without using raw SQL, is to use either select_related() or Django's double_underscore notation - neither of which work on many-to-many relationships in Django 1.2 or less. However, Django's double_underscore notation work on many-to-many in Django 1.3, so you can do the following:

userProfile.objects.values('boughtCoupons__name', 'usercoupons__date')

You have to list all the fields that you need, as far as I know, with this method which makes it a bit of a pain but never the less it is an option.