SQL Query zSRO MOB Drops

USE SRO_VT_SHARD;

SELECT innertable.MonsterID,
       innertable.Monster,
       innertable.ItemID,
       _RefObjCommon.CodeName128 AS Item
FROM   (SELECT   _RefObjCommon.CodeName128 AS Monster,
                 _RefMonster_AssignedItemDrop.RefMonsterID AS MonsterID,
                 _RefMonster_AssignedItemDrop.RefItemID AS ItemID
        FROM     _RefMonster_AssignedItemDrop, _RefObjCommon
        WHERE    _RefMonster_AssignedItemDrop.RefMonsterID = _RefObjCommon.ID
        GROUP BY _RefObjCommon.CodeName128, _RefMonster_AssignedItemDrop.RefMonsterID, _RefMonster_AssignedItemDrop.RefItemID) AS innertable, _RefObjCommon
WHERE  innertable.ItemID = _RefObjCommon.ID;