I have tried similar things but I never seem to be able do it without using DB:raw, if you find a way I would love to know.
Setting::select("settings.*")
->leftJoin(DB::raw("(SELECT COUNT(*) AS counter FROM favorites GROUP BY setting_id) favorites", "favorites.setting_id", "=", "settings.id")
->where("settings.state", "=", 1)
->orderBy("favorites.counter", "DESC");
Last updated
1 year ago.
0
Hi ! Are you sure your solution works because you don't return 'favorites.setting_id' from your leftJoin raw select so Eloquent can't perform the ON join clause.
Last updated
1 year ago.
0
Maybe bellow link example can help you : http://itsolutionstuff.com/post/laravel-5-join-with-subquery-i...
0
Sign in to participate in this thread!
Moderators
-
driesvints
Joined 16 Dec 2013
-
joedixon
Joined 23 Jun 2014
-
tvbeek
Joined 8 Jan 2018
-
tomhatzer
Joined 28 Oct 2021
Laravel
Laravel News
Laracasts
Laravel Podcast