101

SELECT id, subject, body, view_href, author.view_href, author.id, author.login, board.id, author.avatar.profile, author.rank, post_time, post_time_friendly, conversation.last_post_time, conversation.last_post_time_friendly, conversation.solved, conversation.thread_style, replies.count(*), board.view_href, board.title FROM messages WHERE board.id = 'BusinessResources' and depth = 0 ORDER BY conversation.last_post_time DESC LIMIT 10 OFFSET 100