53 Comments - Last post 2 hours ago by WickedVisage
1,127 Comments - Last post 4 hours ago by Gamy7
3 Comments - Last post 4 hours ago by AdJ
8 Comments - Last post 6 hours ago by Abletoburn
21 Comments - Last post 6 hours ago by Chris76de
190 Comments - Last post 9 hours ago by aperager
17 Comments - Last post 11 hours ago by RealJokerini
26,856 Comments - Last post 8 minutes ago by 420UNKNOWN
461 Comments - Last post 37 minutes ago by Cloverleaf
750 Comments - Last post 41 minutes ago by juansebastian28
249 Comments - Last post 43 minutes ago by CloudyChips
1,454 Comments - Last post 43 minutes ago by CarlosPotato
26 Comments - Last post 57 minutes ago by Delisper
24 Comments - Last post 1 hour ago by Aldcoran
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.