/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 vote273 views1 answer
Laravel migration first or model first
PHP Laravel
7 votes283 views4 answers
How get role of user in laravel spatie
PHP Laravel
0 vote310 views1 answer
Laravel Excel numbers formatted as text still appearing as number
PHP Laravel
1 vote285 views1 answer
Get age with carbon in laravel
PHP Laravel
0 vote309 views1 answer
Find the next 7 date data in laravel eloquent
PHP Laravel
0 vote310 views1 answer
Laravel mysql specified key was too long
PHP Laravel
0 vote288 views1 answer
Download data from s3 and save to local disk laravel
PHP Laravel
0 vote309 views1 answer
Model find by certain column laravel
PHP Laravel
0 vote304 views1 answer
Laravel convert querybuilder to string
PHP Laravel
0 vote298 views1 answer
Laravel get current domain
PHP Laravel