SELECT t.topic_id, t.topic_title, t.topic_last_post_id, pt.post_text
FROM phpbb_topics AS t, phpbb_posts AS p, phpbb_forums AS f, phpbb_posts_text AS pt
WHERE t.forum_id = f.forum_id
AND f.auth_read = 0
AND t.forum_id NOT IN(6, 9, 10)
AND p.post_id = t.topic_last_post_id
AND pt.post_id = t.topic_last_post_id
AND t.topic_moved_id = 0
ORDER BY p.post_id DESC LIMIT 10
