不好意思,写错了SELECT AID,targetMapID,(SELECT COUNT(AID) FROM useraction WHERE AID = tem.AID) AS hits, time FROM useraction tem WHERE (time =(SELECT MAX(time) FROM useraction WHERE AID = tem.AID)) order by hits desc limit 10
调试欢乐多
难道是不支持复合查询??郁闷!