SELECT COUNT(*) AS repetitions, lastip FROM accounts GROUP by lastip HAVING repetitions > 4