19 Comments - Last post 1 minute ago by reigifts
23 Comments - Last post 8 minutes ago by axlnase
1,134 Comments - Last post 30 minutes ago by adeyke
53 Comments - Last post 2 hours ago by wigglenose
1,170 Comments - Last post 3 hours ago by Southrobin
20 Comments - Last post 3 hours ago by Mayanaise
23 Comments - Last post 4 hours ago by Axelflox
1,653 Comments - Last post 31 seconds ago by Mdk25
86 Comments - Last post 8 minutes ago by Shurraxxo
12 Comments - Last post 22 minutes ago by Lugum
30 Comments - Last post 32 minutes ago by NB264
45 Comments - Last post 44 minutes ago by f300
14 Comments - Last post 53 minutes ago by BroilKing
180 Comments - Last post 55 minutes ago by Abominati0n
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.