蛋疼的 查询,

explain select * from IMUser as u,(select *from IMMessage order by IMMessage.sendData desc) as m where (m.messageSenderId = u.openfireAccountId or m.messageReceiverId = u.openfireAccountId) and (u.openfireAccountId != 1234) group by u.openfireAccountId  

posted @ 2014-03-18 15:47  路在脚下,  阅读(132)  评论(0编辑  收藏  举报