225 Comments - Last post 11 minutes ago by OrbitalBliss
14 Comments - Last post 15 minutes ago by reigifts
172 Comments - Last post 1 hour ago by ManakaGekka
42 Comments - Last post 2 hours ago by grimfandango8888
264 Comments - Last post 2 hours ago by ThePaladin
3 Comments - Last post 3 hours ago by Akylen
35 Comments - Last post 3 hours ago by devotee
56 Comments - Last post 11 minutes ago by CheMan39
117 Comments - Last post 12 minutes ago by reigifts
520 Comments - Last post 14 minutes ago by Ratz0
85 Comments - Last post 17 minutes ago by samwise84
18 Comments - Last post 19 minutes ago by Sakakino
55 Comments - Last post 23 minutes ago by Cjcomplex
10,100 Comments - Last post 25 minutes ago by Ellemby
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.