Last forum post from all forums

This SQL report shows the last message/reply in the forum system. Note thst it will take also the last message even if it is deleted or not approved!

SELECT
  content
FROM
  Post
ORDER BY
  revisionDate desc
LIMIT 1

content

With the new implementation of the user profile data we probably can do it even easier. As we build a robust, neat (,perl) implementation it may be be presented for the core. In this state it will never pass JT, and that is a good thing:)