SELECTatypeagroupIdbmsgbmsgTyp…

SELECT
a.type,
a.groupId,
b.msg,
b.msgType,
b.userTel,
b.toUserTel,
b.STATUS,
b.createTime,
c.tel,
c.nickName,
c.headImg,
d.noReadTotal
FROM
temporary_chat_list a,
messages b,
USER c,
( SELECT COUNT( 1 ) AS noReadTotal FROM messages WHERE groupId = a.groupId GROUP BY groupId ) d
WHERE
a.msgId = b.mId
AND (
( b.userTel = 15111327689 AND c.tel = b.toUserTel )
OR ( b.toUserTel = 15111327689 AND c.tel = b.userTel )
)
ORDER BY
b.createTime