select min(id) as srcid, max(id) as dstid, loginaddr, count(loginaddr) as count from t_login group by loginaddr;
--
FROM 113.109.21.*