Prova questa:

SELECT MAX(reply.data),post.*
FROM reply INNER JOIN post ON reply.post=post.id_post
GROUP BY reply.post