SELECT p.*, t.*, u.user_id, u.username FROM phpbb3_posts p JOIN phpbb3_topics t JOIN phpbb3_users u
      ON p.topic_id = t.topic_id
      AND u.user_id = p.poster_id
      ORDER BY p.post_id DESC LIMIT 9;