use this query
Quote:
USE SRO_VT_SHARD
go
Declare @Itemcode varchar(max) = 'ITEM_CODE_REFOBJCOMMON'
Select Count (*) from _Inventory where RefItemID in (select id from _Refobjcommon where codename128 like @ItemCode)
|
Query result will be how many people in game have the specified item.
