muhammedaksam adlı üyeden alıntı: mesajı görüntüle 
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
http://sqlfiddle.com/#!9/f64a70/1
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COUNT(*) AS total
FROM ips
GROUP BY ip
) u2
ON u1.ip = u2...' at line 5

desteğiniz için teşekkür ederim
böyle bir hata aldım hocam