I am trying to order results by timestamp but, when there is a duplicate timestamp a result is missed out and it gets one less. I don't like getting one less as It's not suppose to happen like that.
qr.d column is a timestamp (example: 2013-08-28 23:04:47)
qr.id is a unique int
I've tried to order things by qr.d but I get only 14 results. when I order things by qr.d,qr.id I still get only 14 results. when I order things only by qr.id I get 15 results.
Here is my sql:
Why is it behaving as if I have asked for UNIQUE results?