SELECT cc.cn

, sum(a.visits) as total_visits

FROM (

SELECT hostname

, COUNT( DISTINCT TIMESTAMP ) AS visits

FROM mslop_login_activity

GROUP BY hostname

) a

JOIN ip

ON INET_ATON( a.hostname ) BETWEEN ip.START AND ip.END

JOIN cc

ON cc.ci=ip.ci

GROUP BY cc.cn

ORDER BY total_visits DESC

LIMIT 0 , 30