Here is the query:
SELECT DISTINCT t1.gid, t2.title FROM screenshots t1, games t2 WHERE t2.id = t1.gid AND t1.status = '1' ORDER BY t1.date_added DESC LIMIT 0, 5
It is supposed to list records from the latest date but it doesn't, it's reveresed. If I use ASC in the ORDER BY, then it works as I want it to. Why is it doing that?
