[IMPORTANT REQUEST] Avoid Duping

[mabejenta]

I am aware that this post is old, but here is my script that came with my server files. I duno who to give credits to, but I would if I knew.

 Spoiler

select ItemUID INTO #CharTemp119 from PS_GameData.dbo.CharItems group by ItemUID having count(*) > 1

SELECT c.CharID,c.CharName,um.UserID,um.UserIp,ci.ItemID, ci.ItemUID,ci.Slot,ci.Bag, ci.Maketime FROM PS_GameData.dbo.CharItems as ci
inner join PS_GameData.dbo.Chars as c on c.CharID = ci.CharID
inner join PS_UserData.dbo.Users_Master as um on um.UserUID = c.UserUID
WHERE ItemUID in (select ItemUID from #CharTemp119 ) order by ItemUID DESC

DROP TABLE #CharTemp119