/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

5 votes112 views5 answers
Group by laravel
PHP Laravel
0 vote112 views1 answer
Laravel htaccess for aws ec2
PHP Laravel
0 vote105 views1 answer
Laravel enable mysql logging
PHP Laravel
8 votes120 views1 answer
Laravel create symbolic link storage
PHP Laravel
22 votes121 views6 answers
Log Laravel
PHP Laravel
4 votes114 views1 answer
Laravel request all except token
PHP Laravel
10 votes117 views6 answers
Table laravel
PHP Laravel
0 vote137 views1 answer
Laravel vue error 500
PHP Laravel
2 votes124 views2 answers
Laravel 8 websockets
PHP Laravel
-1 vote104 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP Laravel