/PHP/Laravel/Count with left join in laravel

Count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')
	->get();

Source: github.com

Count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')    
	->get();

Source: github.com

Count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')gg
	->get();

Source: github.com

Similar codes

1 vote175 views2 answers
Update checkbox value in laravel
PHP Laravel
2 votes166 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
0 vote185 views1 answer
Make controller laravel history open link
PHP Laravel
0 vote160 views1 answer
Install pusher package in laravel
PHP Laravel
0 vote170 views1 answer
Laravel relationship retrieve data
PHP Laravel
0 vote178 views1 answer
Delete previous uploaded image when update laravel
PHP Laravel
5 votes196 views1 answer
Laravel get random row
PHP Laravel
6 votes166 views3 answers
Laravel $loop->iteration
PHP Laravel
0 vote167 views1 answer
Laravel return redirect by stuckOverFlow
PHP Laravel
0 vote129 views1 answer
Redirect with compact laravel
PHP Laravel