/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

17 votes337 views3 answers
Laravel make model controller and migration one time
PHP Laravel
2 votes311 views2 answers
Laravel migration remove unique
PHP Laravel
1 vote268 views1 answer
Persian error laravel
PHP Laravel
20 votes308 views3 answers
Make specific migration laravel
PHP Laravel
5 votes358 views2 answers
Refresh a specific migration laravel
PHP Laravel
0 vote320 views1 answer
Check the existing image in s3 laravel
PHP Laravel
1 vote310 views3 answers
Difference between guard and fillable laravel
PHP Laravel
0 vote348 views1 answer
Delete previous uploaded image when update laravel
PHP Laravel
1 vote282 views1 answer
How to set a validation on a value if its not null in laravel php
PHP Laravel
4 votes266 views2 answers
Laravel get authorization bearer token
PHP Laravel