SELECT zid,COUNT(id) AS numm FROM tables WHERE (timedate BETWEEN '1446220800' AND '1446307200') GROUP BY zid ORDER BY numm DESC;
转载于:https://my.oschina.net/u/1392382/blog/528250
转载于:https://my.oschina.net/u/1392382/blog/528250