Summary

Fix field-based sorting (e.g. by date) on published collection pages. Items were
sorted incorrectly because the DB paginated by manual_order first, then
client-side sort only reordered that subset — giving the wrong items for the
requested sort order.

Changes

• When field-based sorting is active, skip DB-level limit/offset so all items are fetched
• Sort the full item set by the requested field, then apply limit/offset via slice()
• Manual, random, and no-sort modes continue to use DB-level pagination unchanged

Test plan

• Add a collection layer to a page, sort by a date field descending
• Publish the site and verify items appear in correct chronological order
• Test with pagination enabled — verify each page shows the correct sorted subset
• Test with a limit (no pagination) — verify the N most recent items are shown
• Verify manual sort order still works correctly
• Verify random sort still works

Made with Cursor