/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 vote437 views1 answer
Laravel collection min
PHP Laravel
0 vote399 views1 answer
Why phpunit don't work in commend laravel
PHP Laravel
2 votes357 views2 answers
The requested url was not found on this server. laravel
PHP Laravel
0 vote395 views1 answer
Laravel make trait command
PHP Laravel
0 vote368 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
15 votes350 views6 answers
Laravel db transaction
PHP Laravel
0 vote393 views1 answer
Url() inside laravel config files
PHP Laravel
0 vote426 views1 answer
Laravel Testing send raw data in GET method
PHP Laravel
5 votes399 views3 answers
Merge collections laravel
PHP Laravel
0 vote424 views1 answer
How to conditional values in old value or edit new value with validsation faild to redirect back in laravel
PHP Laravel