Level 50
//relation in Product
public function reviews()
{
return $this->hasMany(Review::class);
}
//query
Product::withCount('reviews')->withAvg('reviews', 'rating')->get();
2 likes
Aug 26, 2021
7
Level 1
WithCount and WithAvg both in a query
How can i use withCount and withAvg both inside a query?
I want reviews count and avg for all users.
Level 1
@s4muel Isn't it pulling reviews 2 times from database?
1st with count and 2nd with avg?
Level 50
this is the query it generates:
select "product".*, (select count(*) from "review" where "product"."id" = "review"."product_id") as "review_count", (select avg("review"."rating") from "review" where "product"."id" = "review"."product_id") as "review_avg_rating" from "product"
1 like
Level 55
@iamarbabhussain you can try the way suggested by @s4muel and another way - join the table and add 2 aggregation columns in select for this join, and see which one will works faster in your way
1 like
Level 1
@silencebringer join will be better and fast. But i was eager to know if @s4muel suggested way pulls reviews 2 times from database or not?
Level 55
@iamarbabhussain it do not pulls the data, it performs aggregation on db data and returns just aggregated result
1 like
Level 1
okay cool. thanks for your time man! i'll mark @s4muel answer as best because of specificity with my question but your answer is also great.
Please or to participate in this conversation.