select bbs_data.*,bbs_topic.counter,bbs_topic.re_counter,bbs_topic.islock,bbs_topic.istop,bbs_topic.isgood,user_data.username as u_username,user_data.nname as u_nname,user_data.sex as u_sex,user_data.whe as u_whe,user_data.qq as u_qq,user_data.email as u_email,user_data.url as u_url,user_data.face as u_face,user_data.tim as u_tim,user_data.remark as u_remark,user_data.bbs_counter as u_bbs_counter,user_data.emoney as u_emoney,user_data.integral as u_integral,user_data.power as u_power,user_data.popedom as u_popedom from user_data inner join ( bbs_topic inner join bbs_data on bbs_data.reply_id=bbs_topic.id ) on bbs_data.username=user_data.username where bbs_data.forum_id=2 and bbs_data.reply_id=296 order by bbs_data.id