Unable to fetch correct data using join subquery in laravel

Question

$serviceId = Service::select('id')->where('provider_id', Auth::user()->id)->where('is_deleted', 0);
$list = DB::table('service_galleries')
            ->where('is_deleted', 0)
            ->joinSub($serviceId, 'sid', function ($qry) {
                $qry->on('service_galleries.service_id', '=', 'sid.id');
            })->get();

From the above code I need id of every row in service galleries table but is return service_id in the field of id, which means service_id and id is same

Try the leftJoinSub

linktoahref
– linktoahref

2023-05-29 09:57:47 +00:00
Commented May 29, 2023 at 9:57 — linktoahref
– linktoahref, Commented May 29, 2023 at 9:57

Edmon Belchev · Accepted Answer · 2023-05-29 14:48:41Z

0

Why dont you use Laravel's Eloquent built in relationships ? This could save you a lot of headaches.

For example in your Service model you can create a function for example:

public function galleries(){
    $this->hasMany(ServiceGalleries::class);
}

And in your ServiceGalleries model (don't know the actual name)

public function service(){
    $this->belongsTo(Service::class);
}

answered May 29, 2023 at 14:48

Edmon Belchev

3973 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

francisco Over a year ago

for performance time. ex: laravel do where exists when is slower than a join.

Collectives™ on Stack Overflow

Unable to fetch correct data using join subquery in laravel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related