Active Auctions:

Order: Sorted by the time they will end soonest, and then by the most recent start time.

Explanation: Imagine you are at a live auction event. You want to know which items will be sold next, right? This is exactly how active auctions are displayed. The ones ending soonest are shown first so you don't miss out. If two auctions end at the same time, the one that started more recently is shown higher up. This way, you're always aware of the most urgent and relevant auctions.


Upcoming Auctions:

Order: Sorted by the time they will start soonest, and then by the latest end time.

Explanation: For auctions that haven't started yet, you probably want to know which ones are coming up soon. That's why upcoming auctions are listed by the soonest start time. If two auctions start at the same time, the one that will run the longest is shown first. This ensures you know which auctions to prepare for and which ones you'll have more time to participate in once they start.


Completed Auctions:

Order: Sorted by the most recent end time, and then by the most recent start time.

Explanation: When looking at past auctions, it's usually most interesting to see the latest results. That's why completed auctions are shown with the ones that ended most recently at the top. If two auctions ended at the same time, the one that started more recently is shown higher up. 


Summary:

- **Active Auctions:** Focuses on urgency, showing those ending soonest first.

- **Upcoming Auctions:** Focuses on what's coming next, showing those starting soonest first.

- **Completed Auctions:** Focuses on the latest results, showing those ending most recently first.


This ordering logic helps users quickly find the most relevant information depending on whether they are interested in ongoing, upcoming, or past auctions.