|
|
error: select topic_id, post_time, post_text, post_subject, count(*)-1 as count, username, user_id, forum_id from phpbb_posts left join phpbb_posts_text on phpbb_posts.post_id=phpbb_posts_text.post_id left join phpbb_users on phpbb_users.user_id=phpbb_posts.poster_id where forum_id=9 group by topic_id order by post_time desc |