/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 vote123 views1 answer
Class 'illuminate support facades input' not found laravel 7
PHP Laravel
0 vote125 views1 answer
Media library laravel maximum allowed size
PHP Laravel
5 votes117 views2 answers
In laravel date duration validation rule
PHP Laravel
1 vote129 views3 answers
Queue jobs in laravel
PHP Laravel
0 vote111 views1 answer
Laravel database engine innodb
PHP Laravel
0 vote125 views1 answer
Get record of last 24 hours in laravel
PHP Laravel
0 vote120 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
7 votes137 views4 answers
With message in laravel
PHP Laravel
12 votes118 views2 answers
Timestamp false in laravel
PHP Laravel
39 votes72 views2 answers
Create request laravel command
PHP Laravel