/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 vote145 views1 answer
Test lockForUpdate laravel
PHP Laravel
1 vote141 views4 answers
Laravel unique id
PHP Laravel
31 votes131 views6 answers
Update or create laravel
PHP Laravel
11 votes145 views2 answers
Laravel mass update relationship
PHP Laravel
0 vote139 views1 answer
Install laravel jetstream inertia js
PHP Laravel
3 votes134 views1 answer
Laravel firstOrFail
PHP Laravel
0 vote129 views2 answers
Laravel event listener
PHP Laravel
-1 vote257 views1 answer
Laravel seo
PHP Laravel
1 vote132 views2 answers
Get ip address in laravel
PHP Laravel
44 votes140 views4 answers
Laravel random string
PHP Laravel