What's wrong with this code? =/

[eluser]Abel A.[/eluser]
Ok, that's pretty easy them.

You can either use the id or a timestamp as the index.

Code:

SELECT c.id, c.articleid, c.userid, c.commentbody, c.date, c.category, u.username, a.articleurl, a.articletype
FROM comments c
LEFT JOIN user u ON u.userid = c.userid
JOIN article a ON a.articleid = c.articleid
ORDER BY c.date DESC
LIMIT 5

Let me know if you have any questions with the above query.