/Python/How to JOIN three tables with Django ORM

How to JOIN three tables with Django ORM

from django.db import models

class Artist(models.Model):
    name = models.CharField(max_length=60)
    year_established = models.SmallIntegerField()
    votes = models.IntegerField(blank=True, null=True)


class Song(models.Model):
    artist = models.ForeignKey(Artist, related_name='songs')
    title = models.CharField(max_length=5)
    votes = models.IntegerField()


class Fan(models.Model):
    artist = models.ForeignKey(Artist, related_name='fans')
    name = models.CharField(max_length=5)
    votes_casted = models.IntegerField()

Source: stackoverflow.com

How to JOIN three tables with Django ORM

queryset = Artist.objects.select_related(
    'songs', 'fans'
).filter(songs__title__icontains='love', fans__votes_casted__gte=100)

Source: stackoverflow.com

Similar codes

8 votes170 views6 answers
Fizzbuzz program in python
Python
1 vote204 views1 answer
Replace multiple different substrings in python
Python
37 votes205 views6 answers
Import beautifulsoup
Python
16 votes189 views3 answers
Python average function program
Python
11 votes246 views2 answers
Yesterday in python
Python
3 votes182 views1 answer
PowerShell says “execution of scripts is disabled on this system.”
Python
0 vote185 views1 answer
Convert .tiff image stack to unit8 format
Python
0 vote192 views1 answer
Pandas isin another dataframe column
Python
2 votes185 views1 answer
How to reapete the code in python
Python
0 vote188 views1 answer
Access key through value python
Python