3 Comments - Last post 21 minutes ago by Mondtaube
346 Comments - Last post 25 minutes ago by Zepy
45 Comments - Last post 46 minutes ago by ChrisKutcher
77 Comments - Last post 50 minutes ago by pb1
2 Comments - Last post 1 hour ago by molu13
45 Comments - Last post 1 hour ago by Abletoburn
71 Comments - Last post 7 hours ago by lostsoul67
125 Comments - Last post 1 minute ago by GediKnight
162 Comments - Last post 4 minutes ago by TinaG
81 Comments - Last post 8 minutes ago by Fluffster
9 Comments - Last post 8 minutes ago by ngoclong19
488 Comments - Last post 11 minutes ago by Swordoffury
500 Comments - Last post 32 minutes ago by GreyF0xx
30 Comments - Last post 36 minutes ago by GeekDoesStuff
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.