UNION 语句
,在此整理一番 …
当前用户ID
即可
为了便于阅读,缩进如下:SELECT count(is_read = 0 or null) AS count_no_read,friend_id,uni_table.content,log_time,type,user_name,picture
FROM (
SELECT to_id as friend_id,content,1 as is_read,log_time,type
FROM tp5_xchat_logs WHERE (from_id = 1) AND (to_id <> 1)
UNION
SELECT from_id as friend_id,content,is_read,log_time,type
FROM tp5_xchat_logs WHERE (from_id <> 1) AND (to_id = 1)
ORDER BY log_time desc
)AS uni_table
INNER JOIN tp5_xadmins a on friend_id = a.id GROUP BY friend_id ORDER BY log_time DESC;