聊天记录列表sql语句

聊天记录列表：

SELECT to_id, content, type, `status`, add_time, sum(`status`) AS unread_num FROM ( SELECT ( CASE WHEN user_id = %d THEN to_id ELSE user_id END ) AS to_id, (user_id + to_id) AS g_id, content, type, `status`, add_time FROM hengtu_wxapp_im WHERE (user_id = %d OR to_id = %d) ORDER BY add_time DESC ) t GROUP BY g_id ORDER BY add_time DESC

聊天记录详情：

SELECT user_id, to_id, content, type, `status`, add_time FROM hengtu_wxapp_im WHERE ( user_id = %d AND to_id = %d ) OR ( user_id = %d AND to_id = %d ) ORDER BY add_time ASC