/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 vote236 views1 answer
How to check if a url has a certain word in laravel
PHP Laravel
1 vote221 views2 answers
Cart::subtotal in laravel
PHP Laravel
0 vote227 views1 answer
Create symbolic in lumen laravel
PHP Laravel
17 votes221 views4 answers
Laravel with trashed
PHP Laravel
0 vote381 views1 answer
Make model inside module laravel
PHP Laravel
0 vote220 views1 answer
Laravel collection all
PHP Laravel
1 vote216 views1 answer
Laravel Post model for flat file CMS
PHP Laravel
2 votes225 views3 answers
Laravel where created_at today
PHP Laravel
3 votes232 views1 answer
Laravel send post request from controller
PHP Laravel
19 votes226 views6 answers
Laravel Route Group
PHP Laravel