SELECT kullanici_id,COUNT(DISTINCT(ip_adres))
FROM kullanicilar
GROUP BY kullanici_id
having COUNT(DISTINCT(ip_adres))>1