47 Comments - Last post 1 hour ago by GeekDoesStuff
37 Comments - Last post 1 hour ago by OneManArmyStar
11 Comments - Last post 2 hours ago by drjoenh
7 Comments - Last post 2 hours ago by OneManArmyStar
47,380 Comments - Last post 4 hours ago by ManOman
210 Comments - Last post 5 hours ago by Heathh
315 Comments - Last post 6 hours ago by Formidolosus
227 Comments - Last post 2 minutes ago by CelestialFrog
5 Comments - Last post 42 minutes ago by fernandopa
17,654 Comments - Last post 44 minutes ago by Belmasv
21 Comments - Last post 1 hour ago by CakeGremlin
3,997 Comments - Last post 1 hour ago by ba2
10,134 Comments - Last post 1 hour ago by EveryShadeOfLife
6,832 Comments - Last post 1 hour ago by Oppenh4imer
Users who give away a bunch of gifts at the same time, often copy/paste the stard/end dates into their respective fields for every giveaway. So an ORDER BY StartDate DESC doesn't have a definite order for those games.
When browsing the list of giveaways by new, this results in the order of those set of giveaways being random on each reload of the page. This becomes especially cumbersome, if the list spreads over more than one page, since the user browsing the list has to reload the pages multiple times to have a reasonable change of having seen all giveaways.
Proposed solution: Amend the ORDER BY statement at the end with lowest priority by something like the GiveawayId (the 5 character long unique string for every giveaway) or any other UNIQUE property of that giveaway. This would result in the same ordering on each reload and no missed giveaways.
Comment has been collapsed.