SELECT COUNT(*) - COUNT(DISTINCT lastip) AS 'duplicates' FROM accounts