Had a bit of an issue - and still do - with sorting returned database results; all posts are returned in descending creation date order, which is expected.
Unfortunately, due to the whole date-grouping-thing where multiple posts on the same day only use one date heading to reduce visual clutter, the posts for said day would be sorted in reverse, as a side-effect of the overreaching creation date ordering above.
I briefly tried to perform a sub-sort as part of the initial SQL query but I didn't get anywhere. I'm still not sure how to fix this without creating additional arrays and sorting those. That'll be saved as a last resort.