[CLUB]
[/CLUB]
SQL:
/*PET ÇANTASI ITEM KONTROLÜ*/
select pet.ID as pet_id, (select top 1 chr.CharName16 from _Char as chr
right join _Inventory as env
on env.CharID = chr.CharID
right join _Items iitem
on env.ItemID = iitem.ID64
where iitem.Data = pet.ID) as karakter_adi, cmn.CodeName128, itm.OptLevel, itm.Data as Total from _Char as chr
right join _Inventory as inv
on chr.CharID = inv.CharID
right join _Items as itm
on itm.ID64 = inv.ItemID
right join _InvCOS as petinv
on itm.ID64 = petinv.ItemID
right join _RefObjCommon as cmn
on cmn.ID = itm.RefItemID
right join _CharCOS pet
on pet.ID = petinv.COSID
where cmn.CodeName128 like '%ITEM_ETC_SD_TOKEN_02%'
