Ordering does not work with Series checked

[pashiav]

Describe the bug
Bug from #4952.
Ordering does not work with Series tool checked in Query Builder. The results are either not in the correct order, or do not change their order at all when querying.

To Reproduce

1. Go to Queries -> Collection Object table (https://calvertmarinemuseum20250206-issue-2000.test.specifysystems.org/specify/query/new/collectionobject/)
2. Add catalogNumber and guid to the query
3. Check Series -> Click Query
4. Click on the column header to see that ordering does not work either by:
   • Incorrectly ordering
   • Results' order not changing at all

Expected behavior
Ordering should work with Series checked.

Screen.Recording.2025-03-03.at.9.31.14.AM.mov

Issue Recording
1. Incorrectly ordering:
Collection: Mollusca

Screen.Recording.2025-03-03.at.9.32.00.AM.mov

2. Results' order not changing at all: from #4952 (review) recording
Collection: Invertebrates

Screen.Recording.2025-02-26.at.8.50.28.AM.mov

Additional Context
Original comment: #4952 (review)

---

• OS: macOS Sonoma
• Browser: Chrome
• Specify 7 Version: issue-2000 -> when merged production
• Database Name: calvertmarinemuseum20250206
• Collection name: Mollusca & Invertebrates
• User Name: spadmin
• URL: https://calvertmarinemuseum20250206-issue-2000.test.specifysystems.org/specify/query/new/collectionobject/

Specify 7 System Information - 2025-03-03T15_47_43.825Z.txt

[pashiav]

I noticed that with this query: https://calvertmarinemuseum20250206-issue-2000.test.specifysystems.org/specify/query/16/

Ordering does work, but it is not automatically ascending - the initial results of this query seem to be in random order.

Screen.Recording.2025-03-03.at.12.13.16.PM.1.mov