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.
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