/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 vote340 views1 answer
Onclick call route laravel
PHP Laravel
0 vote305 views1 answer
Target class admin homecontroller does not exist laravel 8
PHP Laravel
1 vote265 views2 answers
Laravel model set new attribute
PHP Laravel
2 votes353 views6 answers
Composer create project laravel 7
PHP Laravel
5 votes310 views3 answers
Laravel drop column if exists
PHP Laravel
4 votes302 views2 answers
Laravel collection count
PHP Laravel
7 votes332 views3 answers
How to show validation error in laravel blade
PHP Laravel
8 votes323 views1 answer
Laravel sotrage linkl
PHP Laravel
0 vote339 views1 answer
Laravel find or fail exception
PHP Laravel
5 votes293 views2 answers
Laravel encrypt decrypt
PHP Laravel