查询某个UA下，IP访问情况

SELECT * from
    (SELECT ClientIp,
        count(ClientIp) AS IPCount
    FROM AccessRecord
    WHERE UserAgent = 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1'
    GROUP BY  ClientIp)
ORDER BY  IPCount DESC limit 100