SELECT r.*, t.* FROM replies r LEFT JOIN topics t ON(r.topic_id=t.id) ORDER BY r.reply_added DESC LIMIT 0,1

I have optimistic thoughts, even though sometimes (if not always) life's a bitch.