SELECT QUserID, QNumber, QDepartID, DBSubject,DBDate,DBVoice, QIssueDate, QReply, QType, QModID, QMainCate, QSubCate, UUserName,DBWCount,count(RUserID) as NUM from tbReply,tbQuestion,tbUser,tbDatabase WHERE QUserID *= RUserID AND QNumber *= RNumber and DBID=QDBID and DBSource=QDBSource AND QUserID = UUserID AND QModify <> '4' and ((QType='1') or (QType='3')) GROUP BY QUserID,QNumber,QDepartID, DBSubject, DBVoice, DBDate, QIssueDate, QReply, QFlag, QType, DBWCount, QModID, QMainCate, QSubCate, UUserName ORDER BY DBDate DESC