/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 vote211 views2 answers
Where clause with paginate laravel multiple column
PHP Laravel
0 vote212 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP Laravel
1 vote203 views1 answer
Autoload file laravel
PHP Laravel
0 vote223 views1 answer
Entrust laravel
PHP Laravel
0 vote226 views3 answers
Laravel 7 pagination with search filter
PHP Laravel
4 votes213 views1 answer
Laravel validation numeric vs integer
PHP Laravel
40 votes206 views6 answers
Laravel create migration
PHP Laravel
0 vote213 views1 answer
Laravel httaccess for apache
PHP Laravel
1 vote198 views4 answers
Laravel module package
PHP Laravel
13 votes196 views3 answers
Laravel string
PHP Laravel