title: Django Left join how
body: <p>I fairly new to Django and stuck with creating a left join in Django. I tried so many, but none of them seems to be working:</p>
  <p>The query I want to translate to Django is:</p>
  <pre><code>select ssc.id
        ,mgz.Title
        ,tli.id
        ,tli.Time
    
  from Subscription ssc
  
  join Person prs
    on ssc.PersonID = prs.id
   and prs.id = 3
  
  join Magazine mgz
    on mgz.id = ssc.MagazineID
   and mgz.from &lt;= date.today()
   and mgz.until &gt; date.today()
  
  left join TimeLogedIn tli
    on tli.SubscriptionID = ssc.id
   and tli.DateOnline = date.today()
  </code></pre>
  <p>The model I'm using looks like this:</p>
  <pre><code>class Magazine(models.Model):
        Title = models.CharField(max_length=100L)    
        from = models.Datefield()
        until = models.Datefield()
        Persons = models.ManyToManyField(Person, through='Subscription')
  
  class Person(models.Model): 
        user = models.OneToOneField(User, on_delete=models.CASCADE)
        Magazines = models.ManyToManyField(Magazine, through='Subscription')
  
  class Subscription(models.Model):
        MagazineID = models.ForeignKey(Magazine,on_delete=models.CASCADE)
        PersonID = models.ForeignKey(Person,on_delete=models.CASCADE)
  
  class TimeLogedIn(models.Model):
        SubscriptionID = models.ForeignKey('Subscription', on_delete=models.CASCADE)
        DateOnline = models.DateField()
        Time = models.DecimalField(max_digits=5, decimal_places=2)
  </code></pre>
  <p>Like I said, tried so many but no succes and now I don't know how to do this in Django ORM , is it even possible? I created already a raw-query and this is working ok, but how to create this in Django ORM?</p>