/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 vote153 views1 answer
Get the user detail inside the constructor Laravel
PHP Laravel
1 vote162 views1 answer
Why laravel site loading only
PHP Laravel
0 vote165 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
2 votes164 views1 answer
Proper permission webserver laravel
PHP Laravel
15 votes187 views3 answers
Get id user login laravel
PHP Laravel
0 vote161 views1 answer
Laravel first or with callback
PHP Laravel
0 vote174 views3 answers
Embed the site when you click on the link laravel
PHP Laravel
0 vote162 views1 answer
Laravel repository update multiple row
PHP Laravel
26 votes160 views6 answers
Laravel model with migration
PHP Laravel
7 votes164 views3 answers
Laravel append array to array
PHP Laravel