[CLUB]
[/CLUB]
SQL:
select G.Name AS GuildName, M.CharName AS KarakterAdı,CodeName128 AS İtemName, e.EventTime as Zaman,E.Serial64 AS SeriNo ,CASE
WHEN E.Operation = 119 THEN 'Item koydu'
WHEN E.Operation = 120 THEN 'Item aldı'
END AS AlışVeriş
from SRO_VT_LOG.._LogEventItem E
inner join SRO_VT_SHARD.._GuildMember M on M.CharID =E.CharID
inner join SRO_VT_SHARD.._RefObjCommon C on C.ID=E.ItemRefID
inner join SRO_VT_SHARD.._Guild G on G.ID =M.GuildID
Where Operation in (119,120)
and G.Name like 'SilkroadPvP'-- SilkroadPvP yazan yere Guild Name girilecek
Order by E.EventTime Desc
