Bilgi Vsro İtem ve Gold Sıralama Arama , Basit Prosedür

USE SRO_VT_SHARD
select top 100 it.OptLevel, ch.CharName16, obj.CodeName128, obj.Country
from _Items as it
LEFT JOIN [dbo].[_Inventory] as inv ON it.ID64 = inv.ItemID
LEFT JOIN [dbo].[_Char] as ch ON inv.CharID = ch.CharID
LEFT JOIN [dbo].[_RefObjCommon] as obj ON it.RefItemID = obj.ID
where CODENAME128 NOT LIKE '%STONE%'
ORDER BY it.OptLevel DESC

USE SRO_VT_SHARD
SELECT * FROM _char Order BY RemainGold DESC

Use SRO_VT_SHARD
Select IT.ID64, IT.OptLevel As Plus, INV.CharID, CH.CharName16, REF.CodeName128 From _RefObjCommon As REF
Right Join _Items As IT On IT.RefItemID = REF.ID
Right Join _Inventory As INV On INV.ItemID = IT.ID64
Right Join _Char as CH On CH.CharID = INV.CharID
Where CodeName128 like 'ITEM_EU_%_11_A_RARE'