/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

0 vote168 views1 answer
Reverse array laravel
PHP Laravel
37 votes173 views6 answers
Laravel create or update
PHP Laravel
1 vote201 views1 answer
Laravel pagination publish command
PHP Laravel
9 votes157 views6 answers
Laravel current url
PHP Laravel
2 votes137 views2 answers
“In fortify.php line 134:Class 'Laravel\Fortify\Features' not found ” Code Answer’s
PHP Laravel
5 votes156 views2 answers
Laravel 8 routes namespace
PHP Laravel
0 vote158 views1 answer
Laravel denny request by ip
PHP Laravel
10 votes133 views4 answers
Laravel migration set default value
PHP Laravel
18 votes187 views5 answers
Create model, controller and migration in single command laravel
PHP Laravel
7 votes151 views2 answers
Laravel how to check if there are record exists
PHP Laravel