获取最近联系人列表,显示联系人最新的一条消息

SELECT * FROM(
SELECT * FROM(

#查询最近发过消息的联系人
SELECT
im.message_id,im.message_receiver as mobile,im.message_content
FROM
    iddb.id_im_message as im
WHERE
    im.message_sender = '13005066609' AND im.message_receiver<> '13005066609'

UNION 

#查询最近接收到信息联系人
SELECT
    im.message_id,im.message_sender as mobile,im.message_content
FROM
    iddb.id_im_message as im
WHERE
    im.message_receiver = '13005066609' AND im.message_sender<> '13005066609'

#按时间倒叙排,这样分组的时候,才能获得最新的信息
) as a ORDER BY a.message_id DESC

) as b GROUP BY b.mobile ORDER BY b.message_id DESC ;