SELECT ip, COUNT(id) as total FROM table GROUP BY ip HAVING total > 1