SELECT ID_TOPIC , subject , MAX(posterTime) AS maxtime FROM messages GROUP BY ID_TOPIC ORDER BY maxtime DESC LIMIT 10