/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 vote309 views1 answer
Select sum in laravel
PHP Laravel
0 vote319 views1 answer
Prevent xss attack in laravel
PHP Laravel
3 votes304 views1 answer
Back route laravel
PHP Laravel
3 votes307 views2 answers
Validate phone number with dial code laravel 8
PHP Laravel
0 vote335 views1 answer
Laravel use variable inside callback function
PHP Laravel
2 votes308 views3 answers
Laravel where created_at today
PHP Laravel
0 vote300 views1 answer
Laravel where between cluse
PHP Laravel
0 vote296 views1 answer
Laravel vue build production
PHP Laravel
0 vote317 views1 answer
Start someones laravel project
PHP Laravel
0 vote325 views1 answer
Laravel env pgsql
PHP Laravel