We can avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) .where(Pet.animal_type == 'cat')) for pet in query: (continues on next prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print(pet.name) # prints: # Kitty # Fido We can do another can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without

avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) .where(Pet.animal_type == 'cat')) for pet in query: prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print(pet.name) # prints: # Kitty # Fido We can do another this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include

We can avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) (continues on next page) 1.2. Quickstart 7 peewee Documentation, Release prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print(pet.name) # prints: # Kitty # Fido We can do another can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people

avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) .where(Pet.animal_type == 'cat')) for pet in query: prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print(pet.name) # prints: # Kitty # Fido We can do another this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include

avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) .where(Pet.animal_type == 'cat')) for pet in query: prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print pet.name # prints: # Kitty # Fido We can do another this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include

We can avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) .where(Pet.animal_type == 'cat')) for pet in query: (continues on next prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print(pet.name) # prints: # Kitty # Fido We can do another can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without

We can avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) .where(Pet.animal_type == 'cat')) for pet in query: (continues on next prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print(pet.name) # prints: # Kitty # Fido We can do another can avoid this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without

avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) .where(Pet.animal_type == 'cat')) for pet in query: prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print(pet.name) # prints: # Kitty # Fido We can do another this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include

avoid the extra queries by selecting both Pet and Person, and adding a join. query = (Pet .select(Pet, Person) .join(Person) .where(Pet.animal_type == 'cat')) for pet in query: prints: # Kitty Bob # Mittens Jr Herb Let’s get all the pets owned by Bob: for pet in Pet.select().join(Person).where(Person.name == 'Bob'): print(pet.name) # prints: # Kitty # Fido We can do another this by performing a JOIN and using a SQL function to aggregate the results. query = (Person .select(Person, fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include

the extra queries by selecting both Pet and Person, and adding a join. >>> query = (Pet ... .select(Pet, Person) ... .join(Person) ... .where(Pet.animal_type == 'cat')) >>> for name ... Kitty Bob Mittens Jr Herb Let’s get all the pets owned by Bob: >>> for pet in Pet.select().join(Person).where(Person.name == 'Bob'): ... print pet.name ... Kitty Fido We can do another cool Once again we’ve run into a classic example of N+1 query behavior. We can avoid this by performing a JOIN and aggregating the records: >>> subquery = Pet.select(fn.COUNT(Pet.id)).where(Pet.owner == Person