This is kind of straight forward.
I want to ORDER BY date DESC Limit 4
and then I want to ORDER BY date ASC
on that result, so just 4-games from the middle of the big table with ASC date order, any ideas?
Just ORDER BY date ASC Limit 4
Does not work!
What I have:
What I get:
What I want: