Django left join sql to django orm

я пишу только sql, django orm так себе, как преобразовать sql в django orm? sql

SELECT ct.id,
    ct.nid,
    ct.`status`,
    ct.create_time,
    bp.id as program_id 
FROM `ct_task` as ct
JOIN program as bp 
on ct.hash_code=bp.hash_code
ORDER BY ct.id DESC LIMIT 0,10

orm

class CTask(models.Model):
   hash_code = models.CharField(max_length=50, null=True, db_index=True)
class Program (models.Model):
   hash_code = models.CharField(max_length=50, null=True, db_index=True)

Вернуться на верх