Citation:

# Time: 130218 3:53:50
# Query_time: 11 Lock_time: 0 Rows_sent: 60 Rows_examined: 1 476 075
SELECT u.user_id, f.forum_id, p.topic_id, p.post_id, pt.post_text, u.username, p.post_time, t.topic_title, t.topic_poster, t.connexes, f.forum_name FROM posts p
LEFT JOIN posts_text pt ON pt.post_id = p.post_id
LEFT JOIN users u ON u.user_id = p.poster_id
LEFT JOIN forums f ON f.forum_id = p.forum_id
LEFT JOIN topics t ON t.topic_id = p.topic_id WHERE !(f.forum_type = 1 ) AND f.forum_id !=58 ORDER BY p.post_time DESC, p.post_time DESC, t.topic_title DESC LIMIT 60;

# Time: 130218 8:25:30
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 873 636
SELECT f.forum_id, f.forum_type, f.forum_name, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, p.poster_id, p.post_time, u.username
FROM posts p, forums f, topics t, users u
WHERE t.topic_id = p.topic_id AND f.forum_id = t.forum_id AND u.user_id = p.poster_id AND f.forum_access != 3 AND f.forum_type = 0 AND f.forum_id != 58
ORDER BY p.post_id DESC LIMIT 10;