Support the ongoing development of Laravel.io →
Database Eloquent
Last updated 1 year ago.
0

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

Sign in to participate in this thread!

Eventy

Your banner here too?

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.