Multi account

[QQers19]

Hello!
I try tu wirte some query's for show multi acc
But i have a problem "Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value '127.0.0.1' to data type int."

 SELECT * FROM PS_UserData.dbo.users_master
Where UserIp >1

SELECT * FROM PS_UserData.dbo.Users_Master c
INNER JOIN PS_UserData.dbo.Users_Master um ON um.UserUID=c.UserUID
WHERE um.UserIp >1

[nubness]

USE PS_UserData
SELECT UserUID, UserID, Pw, UserIp FROM Users_Master
WHERE UserIp IN (SELECT UserIp FROM Users_Master
GROUP BY UserIp
HAVING COUNT(UserIp) > 1)
ORDER BY UserIp

[QQers19]

Thank you

[Autrux]

#moved