24 Comments - Last post 15 minutes ago by CrisR82
40 Comments - Last post 18 minutes ago by FranckCastle
15,549 Comments - Last post 30 minutes ago by GangsterJochen
46,896 Comments - Last post 1 hour ago by drschnell
591 Comments - Last post 1 hour ago by MeguminShiro
772 Comments - Last post 1 hour ago by MeguminShiro
76 Comments - Last post 1 hour ago by BlazeHaze
269 Comments - Last post 15 seconds ago by Sergiio
44 Comments - Last post 1 minute ago by ceeexo
8,017 Comments - Last post 12 minutes ago by Bum8ara5h
139 Comments - Last post 13 minutes ago by Fluffster
809 Comments - Last post 19 minutes ago by Eudoxia
13 Comments - Last post 21 minutes ago by Pent2008
7,202 Comments - Last post 21 minutes ago by Bum8ara5h
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.