Ips

$query = "SELECT COUNT(ip) AS ip.countip, u.id,u.username, u.class, u.added, u.last_access, ip.userid, ip.lastlogin FROM ips AS ip LEFT JOIN users AS u ON ip.userid = u.id WHERE ip.lastlogin > $dt AND ip.type='login' AND ip.countip > 3 GROUP BY u.username ORDER BY u.username ASC";