Checkins with a delay are sorted wrong

[Oxbowatos]

Describe the bug
If e.g. I checkin in a train which derparting at 7am and I get on a train departing 6:30am but has 1 hour delay, the delayed checkin is sorted under the first checkin.

It also happens on the Global Dashboard and Home Dashboard that it's sorted wrong

To Reproduce
Steps to reproduce the behavior:

1. Checkin in a normal Train
2. At your Stop search for a delayed Train/Bus/etc (where the sheduled departure time is under the sheduled departure time of your first Checkin)
3. Look how the Checkins are sorted
4. See that the Checkin with Delay is sorted under the Checkins without Delay

Expected behavior
That the Page sorts the Checkins with the delayed departure time not only the sheduled departure time.

Screenshots
If applicable, add screenshots to help explain your problem.

See how its sorted: (Deleted some fields for privacy reason)

Desktop (please complete the following information):
Any Browser

Smartphone (please complete the following information):
Any Smartphone

[MrKrisKrisu]

This is our current query for the private dashboard:

traewelling/app/Http/Controllers/Backend/User/DashboardController.php

Lines 19 to 37 in 74d3a98

	return Status::with([
	'event', 'likes', 'user.blockedByUsers', 'user.blockedUsers', 'trainCheckin',
	'trainCheckin.originStation', 'trainCheckin.destinationStation',
	'trainCheckin.HafasTrip.stopovers.trainStation'
	])
	->join('train_checkins', 'train_checkins.status_id', '=', 'statuses.id')
	->select('statuses.*')
	->where('train_checkins.departure', '<', Carbon::now()->addMinutes(20))
	->orderBy('train_checkins.departure', 'desc')
	->whereIn('statuses.user_id', $followingIDs)
	->whereNotIn('statuses.user_id', $user->mutedUsers->pluck('id'))
	->whereIn('statuses.visibility', [
	StatusVisibility::PUBLIC->value,
	StatusVisibility::FOLLOWERS->value,
	StatusVisibility::AUTHENTICATED->value
	])
	->orWhere('statuses.user_id', $user->id)
	->latest()
	->simplePaginate(15);

We sort here only according to the planned departure of the Journey:

traewelling/app/Http/Controllers/Backend/User/DashboardController.php

Line 27 in 74d3a98

->orderBy('train_checkins.departure', 'desc')

In order for us to aggregate the data correctly directly we would need to do the following sorts in order:

1. if isset DESC {join}.train_checkins.manual_departure
2. DESC {join}.train_checkins.{join}.train_stopovers.{real_departure}.
3. DESC {join}.train_checkins.{join}.train_stopovers.{planned_departure}.

Since our data structure is a bit complex to build a meaningful and performant query for it I would suggest to do the sorting only on the frontend level so that it looks properly sorted to the user.

[MrKrisKrisu]

ER-Diagram with the relevant tables: