[SQL Query] Show All MOBS and MOBID's and ITEMS DROPPED

This query will show every MOB and MOB ID as well as all ITEMS and ITEM ID's that MOBS have assigned to them. This will not show the drop classes for item groups, only the data within RefMonster_AssignedItemDrop

Code:

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;

MonsterID Monster ItemID Item
38222 MOB_SD_DESERTBUG 24669:ITEM_ETC_SD_TOKEN_03
38223 MOB_SD_SANDBUG 24669:ITEM_ETC_SD_TOKEN_03
38224 MOB_SD_DEMONBUG 24669:ITEM_ETC_SD_TOKEN_03
38225 MOB_SD_DEMONBUG_2 24669:ITEM_ETC_SD_TOKEN_03
38226 MOB_SD_DEMONBUG_3 24669:ITEM_ETC_SD_TOKEN_03
38227 MOB_SD_EVILBUG 24669:ITEM_ETC_S D_TOKEN_03
38228 MOB_SD_SELKION 24669:ITEM_ETC_SD_TOKEN_03
38229 MOB_SD_SANDSTING 24669:ITEM_ETC_SD_TOKEN_03
38230 MOB_SD_ACHNISH 24669:ITEM_ETC_SD_TOKEN_03
38231 MOB_SD_ACHNISHLAMA 24669:ITEM_ETC_SD_TOKEN_03
38232 MOB_SD_MONT 24669:ITEM_ETC_SD_TOKEN_03
And more...

You are welcome.