/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

-2 votes158 views3 answers
Laravel create get id
PHP Laravel
0 vote174 views1 answer
Laravel log query for model (full)
PHP Laravel
4 votes162 views3 answers
Laravel use config
PHP Laravel
0 vote165 views1 answer
Laravel get next and previous record
PHP Laravel
2 votes104 views2 answers
Laravel dump
PHP Laravel
2 votes154 views3 answers
Laravel web php request to redirect to another page
PHP Laravel
10 votes180 views2 answers
Try and catch laravel
PHP Laravel
21 votes148 views4 answers
Laravel where not
PHP Laravel
14 votes154 views2 answers
Laravel database select
PHP Laravel
0 vote137 views1 answer
Laravel query with optional filter
PHP Laravel