Laravel Query

@nishant_nayan

i have used using model eloquent this if this can halp you or you want raw query?

this is not the same you want but kind of

$collection = Orders::join('order_lines', 'order_lines.order_id', '=', 'orders.id')
                                            ->join('products', 'products.id', '=', 'order_lines.product_id')
                                            ->select('products.name', DB::raw('sum(order_lines.quantity) AS Total'))
                                            ->where('orders.user_id', $id)
                                            ->where('orders.created_at', '>=', $newdate)
                                            ->groupBy('order_lines.product_id')
                                            ->orderBy('Total', 'DESC')
                                            ->take(7)
                                            ->get()->toArray();

Thanks For this amazing answer and i've already solved but @palak27 your answer is also amazing

$primary=DB::table('tbl_master_vehicle_specifications_sheet') ->join('tbl_master_vehicle_specifications_temp_conf','tbl_master_vehicle_specifications_temp_conf.primary_id','=','tbl_master_vehicle_specifications_sheet.id')

                ->select('tbl_master_vehicle_specifications_sheet.field_title as field_title' ,'tbl_master_vehicle_specifications_sheet.id as id','tbl_master_vehicle_specifications_sheet.id',DB::raw(' max(tbl_master_vehicle_specifications_temp_conf.id) as mid'))
                ->groupBy('tbl_master_vehicle_specifications_sheet.id')
                ->groupBy('tbl_master_vehicle_specifications_sheet.field_title')
                
                ->orderBy('mid',' desc')
            ->get();

@nishant_nayan thanks for appreciation

@PALAK27 - you deserve it