36 Comments - Last post 3 minutes ago by BanjoBearLV
31 Comments - Last post 16 minutes ago by m0r1arty
83 Comments - Last post 33 minutes ago by PaganFears
633 Comments - Last post 57 minutes ago by Kireato
62 Comments - Last post 3 hours ago by Pika8
19 Comments - Last post 3 hours ago by lafilleange95
93 Comments - Last post 4 hours ago by ewoda
138 Comments - Last post 46 seconds ago by ObsidianSpire
20 Comments - Last post 2 minutes ago by Ekaros
19 Comments - Last post 3 minutes ago by Carenard
11 Comments - Last post 7 minutes ago by Mitsukuni
106 Comments - Last post 7 minutes ago by Vasharal
99 Comments - Last post 8 minutes ago by CultofPersonalitea
264 Comments - Last post 9 minutes ago by krol7
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.