14 Comments - Last post 38 minutes ago by IronKnightAquila
1 Comments - Last post 57 minutes ago by adam1224
15,461 Comments - Last post 2 hours ago by Channel28
8 Comments - Last post 2 hours ago by Axelflox
19 Comments - Last post 4 hours ago by Foxhack
52 Comments - Last post 6 hours ago by zenarcher
42 Comments - Last post 6 hours ago by Roguedust
126 Comments - Last post 2 minutes ago by xxxka
47 Comments - Last post 2 minutes ago by Chris76de
21 Comments - Last post 17 minutes ago by PoeticKatana
842 Comments - Last post 21 minutes ago by kriok
7,144 Comments - Last post 31 minutes ago by Almostn33t
253 Comments - Last post 35 minutes ago by Kyrrelin
122 Comments - Last post 36 minutes ago by Kyrrelin
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.