select travelGroups.groupId,travelGroups.userId,travelGroups.replyTime,addUserName,groupTitle,hits,replyCount,userinfo.userSex,travelGroups.isBest,travelGroups.isTop,travelGroups.addTime from travelGroups,userinfo where userinfo.userId=travelGroups.userId order by replyTime desc