[HIDE]
USE SRO_VT_SHARD
SELECT
A.ID AS MonsterID,
A.CodeName128 AS MobKodu,
B.RefItemID AS ItemCommonID,
C.CodeName128 AS EklenenItemKodu,
B.DropGroupType AS DüşmeGrubuTipi,
B.DropAmountMin AS DüşmeMiktarıMinimum,
B.DropAmountMax AS DüşmeMiktarıMaksimum,
B.DropRatio AS DüşmeOranı
FROM
_RefMonster_AssignedItemDrop AS B
JOIN
_RefObjCommon AS A ON B.RefMonsterID = A.ID
JOIN
_RefObjCommon AS C ON B.RefItemID = C.ID
[/HIDE]
USE SRO_VT_SHARD
SELECT
A.ID AS MonsterID,
A.CodeName128 AS MobKodu,
B.RefItemID AS ItemCommonID,
C.CodeName128 AS EklenenItemKodu,
B.DropGroupType AS DüşmeGrubuTipi,
B.DropAmountMin AS DüşmeMiktarıMinimum,
B.DropAmountMax AS DüşmeMiktarıMaksimum,
B.DropRatio AS DüşmeOranı
FROM
_RefMonster_AssignedItemDrop AS B
JOIN
_RefObjCommon AS A ON B.RefMonsterID = A.ID
JOIN
_RefObjCommon AS C ON B.RefItemID = C.ID
[/HIDE]
