OrderBy Relationship column

@MichalOravec great article, but I have another question since my relationship itself is more complex than the ones in the article. I used this library to make the relationship https://github.com/topclaudy/compoships

 public function salePointRoute()
    {
        return $this->belongsTo(SalePointRoute::class, ['route_id', 'sale_point_id'], ['route_id', 'sale_point_id']);
    }

In this case would I do two join statements one with route_id and the other with sale_point_id?

@msslgomez Just join your 2 tables. That's it. If you need to use 2 columns, use them.

@MichalOravec last question, this is my query, now it's ordered correctly but I have a lot of duplicates (3 vs 9), I know that can be fixed with a ->get()->unique() after but I wanted to understand why that is happening.

$user_route_check_outs = SalePointCheckOut::select('sale_point_check_outs.*')
            ->with('salePoint.salePoint', 'route', 'salePointRoute')
            ->join('sale_point_route', 'sale_point_route.sale_point_id', '=', 'sale_point_check_outs.sale_point_id')
            ->join('sale_point_route as spr', 'spr.route_id', '=', 'sale_point_check_outs.route_id')
            ->whereDate('date', $request->date('filters.date') ?? now())
            ->where('user_id', $request->input('filters.user_id'))
            ->orderBy('sale_point_route.priority');

@msslgomez You joined the same table two times.

$user_route_check_outs = SalePointCheckOut::with('salePoint.salePoint', 'route', 'salePointRoute')
    ->select('sale_point_check_outs.*')
    ->join('sale_point_route', function ($join) {
        $join
            ->on('sale_point_route.sale_point_id', '=', 'sale_point_check_outs.sale_point_id')
            -on('sale_point_route.route_id', '=', 'sale_point_check_outs.route_id');
    })
    ->whereDate('sale_point_check_outs.date', $request->date('filters.date') ?? now())
    ->where('sale_point_check_outs.user_id', $request->input('filters.user_id'))
    ->orderBy('sale_point_route.priority')
    ->get();