Converting mysql queries to laravel syntax

Question

I don't know how to convert subquery to laravel query. How I can convert mysql query to laravel query? this is the query

select vd_id, subCount
from   (select vd_id, count(vd_id) subCount 
        from sell_data
        group by vd_id) sub
        where subCount = (select count(vd_id) maxCount
                          from sell_data
                          group by vd_id 
                          order by maxCount desc limit 1) 
           or subCount = (select count(vd_id) minCount
                          from sell_data
                          group by vd_id 
                          order by minCount asc limit 1) ;

stackoverflow.com/questions/44927663/…

Héctor M.
– Héctor M.

2018-04-04 01:06:14 +00:00
Commented Apr 4, 2018 at 1:06 — Héctor M.
– Héctor M., Commented Apr 4, 2018 at 1:06

Jonas Staudenmeir · Accepted Answer · 2018-04-04 01:30:53Z

2

$from = DB::table('sell_data')->select('vd_id')->selectRaw('count(vd_id) subCount')
    ->groupBy('vd_id');
$results = DB::query()
    ->select('vd_id', 'subCount')
    ->fromSub($from, 'sub')
    ->where('subCount', function($query) {
        $query->selectRaw('count(vd_id) maxCount')
            ->from('sell_data')
            ->groupBy('vd_id')
            ->orderByDesc('maxCount')
            ->limit(1);
    })
    ->orWhere('subCount', function($query) {
        $query->selectRaw('count(vd_id) minCount')
            ->from('sell_data')
            ->groupBy('vd_id')
            ->orderBy('minCount')
            ->limit(1);
    })
    ->get();

answered Apr 4, 2018 at 1:30

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hajae Over a year ago

Thank you for quick response.

Collectives™ on Stack Overflow

Converting mysql queries to laravel syntax

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related