Форум пользователей MySQL

SELECT dle_rev_post.objectid, dle_rev_post.date

FROM dle_rev_objects

LEFT JOIN (
    SELECT dle_rev_post.objectid, MAX(dle_rev_post.date) as max_date FROM dle_rev_post GROUP BY dle_rev_post.objectid
          ) AS subpst
    ON subpst.objectid = dle_rev_objects.id AND subpst.max_date = dle_rev_post.date

 LEFT JOIN dle_rev_post ON dle_rev_objects.id = dle_rev_post.objectid