63 Comments - Last post 10 minutes ago by Mhol1071
57 Comments - Last post 58 minutes ago by DesertEskimo
8 Comments - Last post 1 hour ago by miIk
76 Comments - Last post 1 hour ago by pampuch721
17,605 Comments - Last post 1 hour ago by Carenard
7 Comments - Last post 2 hours ago by BigHairyMan
2,004 Comments - Last post 3 hours ago by seaman
144 Comments - Last post 3 minutes ago by s4k1s
23 Comments - Last post 6 minutes ago by ClapperMonkey
17 Comments - Last post 7 minutes ago by ThePonz
61 Comments - Last post 23 minutes ago by MrOuiOui
49 Comments - Last post 30 minutes ago by maplesyrupghost
71 Comments - Last post 49 minutes ago by LightningCount
200 Comments - Last post 52 minutes ago by ayuinaba
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.