"SELECT m.subject, m.id, m.post_stamp, t.forum_id 
FROM {SQL_TABLE_PREFIX}msg m
INNER JOIN {SQL_TABLE_PREFIX}thread t ON m.thread_id=t.id WHERE m.apr=1  AND m.poster_id=".$u->id."
ORDER BY m.post_stamp DESC LIMIT 1"