27 Comments - Last post 29 minutes ago by Warriot
9 Comments - Last post 35 minutes ago by justachild8
45 Comments - Last post 39 minutes ago by davidpfarrell
235 Comments - Last post 1 hour ago by PsyKo
1,435 Comments - Last post 4 hours ago by CommissarCiaphasCain
49 Comments - Last post 4 hours ago by VincenzoM96
4 Comments - Last post 5 hours ago by ZoOmEr4402
10 Comments - Last post 4 minutes ago by EyeofArrow
86 Comments - Last post 16 minutes ago by spookypannkaka
73 Comments - Last post 22 minutes ago by Volcanic
2,737 Comments - Last post 26 minutes ago by vlad767
909 Comments - Last post 45 minutes ago by DemonsRift
82 Comments - Last post 1 hour ago by 76561198082881386
2 Comments - Last post 1 hour ago by MarvashMagalli
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.