/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

2 votes185 views2 answers
Laravel migration alter column unique
PHP Laravel
0 vote182 views1 answer
Import facade URL laravel
PHP Laravel
2 votes174 views1 answer
How to use model method in controller in laravel
PHP Laravel
-1 vote136 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote176 views2 answers
Laravel collection intersect
PHP Laravel
0 vote189 views1 answer
Get nearby from longitude and latitude in laravel
PHP Laravel
19 votes198 views6 answers
Laravel date validation
PHP Laravel
8 votes221 views3 answers
Laravel check record exists
PHP Laravel
0 vote194 views1 answer
Laravel composer anctum
PHP Laravel
0 vote248 views1 answer
Laravel 8 jwt api authentication
PHP Laravel