SELECT u1.ip, u1.kullaniciadi, u2.total
FROM kullanicilar u1
INNER JOIN
(
    SELECT ip, COUNT(*) AS total
    FROM kullanicilar
    GROUP BY ip
) u2
ON u1.ip = u2.ip
ORDER BY u2.total DESC