46 Comments - Last post 22 minutes ago by pripkun
8 Comments - Last post 41 minutes ago by CelticBatman
25 Comments - Last post 1 hour ago by MeguminShiro
4 Comments - Last post 1 hour ago by MeguminShiro
175 Comments - Last post 2 hours ago by NewbieSA
15,601 Comments - Last post 2 hours ago by STFNro
58 Comments - Last post 3 hours ago by Myrsan
44 Comments - Last post 1 minute ago by mourinhos86
46 Comments - Last post 2 minutes ago by Fluffster
10 Comments - Last post 17 minutes ago by RePlayBe
252 Comments - Last post 17 minutes ago by ayuinaba
0 Comments - Created 25 minutes ago by Lugum
260 Comments - Last post 27 minutes ago by Fluffster
38 Comments - Last post 34 minutes ago by ceeexo
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.