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

38 votes193 views2 answers
Create request laravel command
PHP Laravel
10 votes188 views2 answers
Laravel migration default value not working
PHP Laravel
0 vote217 views1 answer
Woocommerce change "Billing Details" text
PHP
0 vote245 views1 answer
Laravel Deploy in production
PHP Laravel
11 votes235 views2 answers
Get key of value array php
PHP
1 vote219 views1 answer
Convert key to value php
PHP
6 votes227 views3 answers
Previous url laravel
PHP
1 vote255 views2 answers
Fillable vs guarded laravel
PHP Laravel
0 vote225 views1 answer
Carbon between hours
PHP
0 vote222 views2 answers
Php constant
PHP