得到帖子及帖子的最新评论列表

帖子列表


帖子回复列表


显示所有帖子及帖子的最新回复

select t.id, t.title, tb.id, tb.content
from forum_topic t
left join (select * from forum_topic_back where id in (select max(id)  from forum_topic_back where status=1 group by topic_id)) tb on tb.topic_id=t.id 
where t.status=1 
order by t.id desc